🔄 Microsoft Power Automate Tutorial (Beginner → Practical)

 

🔄 Microsoft Power Automate Tutorial (Beginner → Practical)

4

Let’s walk through Power Automate step-by-step, in a way you can even teach your students or use for your LMS/IT training.

🚀 What is Microsoft Power Automate?

Microsoft Power Automate is a tool that helps you:

👉 Automate repetitive tasks
👉 Connect apps (Excel, Outlook, SharePoint, etc.)
👉 Build workflows without heavy coding

🧠 Types of Flows (Very Important)

There are 3 main types you’ll use:

1. ⚡ Automated Flow

• Triggered automatically
• Example: When email arrives → Save attachment

2. 🖱️ Instant Flow

• Triggered manually (button click)
• Example: Click → Send report

3. ⏰ Scheduled Flow

• Runs at a specific time
• Example: Every Monday → Send reminder

🛠️ Step-by-Step: Create Your First Flow

✅ Example: Save Email Attachments Automatically

Step 1: Go to Power Automate

👉 Visit: https://flow.microsoft.com
👉 Sign in with your Microsoft account

Step 2: Create Flow

• Click Create
• Select Automated cloud flow

Step 3: Choose Trigger

Search and select:

👉 “When a new email arrives (V3)” (Outlook)

Step 4: Add Action

Click + New Step

Choose:
👉 Create file (OneDrive / SharePoint)

Step 5: Configure Action

• Folder Path → Where to save files
• File Name → Attachment name
• File Content → Attachment content

Step 6: Save & Test

• Click Save
• Send yourself an email with attachment
• Watch automation happen 🔥

🎯 Practical Use Cases (Perfect for You 🔥)

Since you're into LMS + training, here are powerful ideas:

🎓 Education / Moodle Use

• Auto-send course enrolment emails
• Notify students when results are uploaded
• Save assignment submissions to OneDrive

📊 Admin / Office Work

• Convert Excel data to reports
• Auto-backup files
• Send reminders to staff

💼 Business (CCYI Global Enterprise)

• Auto-send invoices
• Capture leads from forms
• Send WhatsApp/email follow-ups

🔗 Popular Integrations

Power Automate works with:

• Microsoft Excel
• Microsoft Outlook
• SharePoint
• Google Drive
• Dropbox

⚡ Advanced Features (Next Level)

Once you master basics:

• Conditions (IF statements)
• Loops (Apply to each)
• Approvals (for workflows)
• AI Builder (automation + AI)

🎓 Mini Project (Try This Today)

👉 Create a flow:

Trigger: New Google Form submission
Action:

• Save response in Excel
• Send confirmation email

🔥 This is perfect for your:

• Training registrations
• Event signups
• LMS onboarding

🧠 Pro Tips (From Experience)

• Always name your flows clearly
• Use test mode frequently
• Start simple → then scale
• Use templates (huge time saver)

CCYI GLOBAL ACADEMY | LEARNING ARENA

CCYI GLOBAL ACADEMY

Shop beginner-friendly tech courses, practical training tutorials, data tools, web development content, automation, and digital skills courses from Palace Tech Hub.

🛒 Cart: 0 item(s)

Shop by Category

All Courses

CCYI GLOBAL Office Productivity

Microsoft Power Automate Tutorial (Beginner → Practical)

Learn workflow automation, process automation, triggers, and practical Microsoft Power Automate use cases.

₦0,000

Read on Blog

CCYI GLOBAL Office Productivity

Basic Understanding of Microsoft Excel (For Beginners)

Start with worksheets, formulas, formatting, sorting, and beginner spreadsheet productivity.

₦0,000

Read on Blog

CCYI GLOBAL Office Productivity

Excel Tutorial: Pivot Tables, Macros, and VBA

Advance your Excel skills with automation, reporting, data summaries, and VBA concepts.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Web Development

Basic Understanding of Web Development

A simple introduction to how websites work, frontend/backend concepts, and tools beginners need.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Web Development

Basic Understanding of HTML (For Beginners)

Learn the structure of web pages, elements, tags, forms, headings, links, and page layouts.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Web Development

Basic Understanding of CSS / CSS INTRODUCTION

Understand styling, colors, spacing, layouts, selectors, and how CSS transforms plain HTML pages.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Web Development

Basic Understanding of JavaScript (For Beginners)

Learn variables, functions, DOM basics, events, conditions, loops, and website interactivity.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Web Development

Basic Understanding of API (For Beginners)

Understand how applications communicate, exchange data, and connect services through APIs.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Web Development

Basic Understanding of Django (For Beginners)

A beginner introduction to Python-powered web applications using the Django framework.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Web Development

Basic Understanding of Flask (For Beginners)

Discover lightweight Python web development and build simple apps faster with Flask. :contentReference[oaicite:1]{index=1}

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Data Analytics

Basic Understanding of Power BI (For Beginners)

Learn dashboard thinking, reports, visuals, data modeling, and beginner business intelligence workflows.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Data Analytics

Basic Understanding of Pandas (For Beginners)

Handle tables, clean data, load files, and perform beginner data analysis with Pandas.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMYL Data Analytics

Basic Understanding of NumPy (For Beginners)

Understand arrays, numerical computing, and fast calculations for data and scientific work.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Data Analytics

Basic Understanding of Tableau (For Beginners)

Build beginner dashboards and data visualizations using Tableau concepts and workflow basics.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Data Analytics

Basic Understanding of R (For Beginners)

Get started with R programming for statistics, analytics, scripting, and data exploration.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Data Analytics

How To Use Jupyter NoteBook For Data Analysis (Beginner Tutorial)

Use notebooks for Python practice, analysis workflows, code execution, and markdown explanations.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Python & Automation

Basic Understanding of Python (For Beginners)

Learn syntax, variables, functions, logic, loops, and real beginner programming foundations.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Python & Automation

HOW TO CREATE A BOT

An introduction to bot concepts, automation logic, and practical beginner bot building ideas.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Python & Automation

3 PYTHON AUTOMATION PROJECTS FOR BEGINNERS

Practice practical automation with beginner-friendly projects that build real confidence.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Python & Automation

Automate with Python – Full Course for Beginners

Discover scripts, repetitive task automation, beginner Python workflows, and useful mini projects.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMYL Database & SQL

Basic Understanding of MySQL (For Beginners)

Start learning relational databases, tables, records, queries, and database concepts with MySQL.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Database & SQL

Learn SQL Beginner to Advanced in Under 4 Hours

A faster SQL journey covering beginner to more advanced database querying concepts. The blog lists this among older posts. :contentReference[oaicite:2]{index=2}

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Database & SQL

Learn 12 Basic SQL Concepts in 15 Minutes

Quickly grasp essential SQL ideas and project-focused beginner query thinking.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Database & SQL

Remote Dictionary Server in-memory data store

Explore beginner concepts around in-memory data storage and fast-access data systems.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY AI & Tech Trends

MASTER AI: TURN MONTHS OF WORK INTO MINUTES

Use AI tools to increase productivity, compress workflows, and speed up content or office tasks.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY AI & Tech Trends

Basic Understanding of Internet of Things (IoT) – For Beginners

Learn connected devices, sensors, smart systems, and beginner IoT thinking.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY AI & Tech Trends

10 Incredible New Technologies That Have Changed The World

A broader technology awareness course useful for beginners and digital literacy audiences.

₦0,00

Read on Blog

CCYI GLOBAL ACADEMY AI & Tech Trends

25 technologies that have changed the world

Explore foundational technology changes and how innovation shapes society and work.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY AI & Tech Trends

The 7 Main Ways Technology Impacts Your Daily Life

A practical digital awareness course for students, beginners, and general audiences.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY AI & Tech Trends

Technology In Our Life Today And How It Has Changed

A simple tech awareness training focused on modern life, transformation, and relevance.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY AI & Tech Trends

Data Is The New Oil -- And That's A Good Thing

Understand the value of data, analytics culture, and why data matters in modern work.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY Data Analytics

Data was, Analytics is, the New Oil

A practical thought-leadership training around analytics relevance and insight-driven work.

₦0,000

Read on Blog

CCYI GLOBAL ACADEMY AI & Tech Trends

TECHNOLOGY IS THE NEW OIL

A broad technology awareness teaching centered on digital opportunity and modern relevance.

₦0,000

Read on Blog

No courses found in this category.

Course Cart

Total: ₦0

Course Checkout

Full Name

Phone Number

Address / School / Location

Pay by Bank Transfer

Bank Name: UNITED BANK FOR AFRICA

Account Name: CCYI GLOBAL ENTERPRISE

Account Number: 1017417XXX

After payment, click “Confirm Payment on WhatsApp” below and send your proof of payment.

Order Summary

Total: ₦0

📊 MICROSOFT EXCEL TUTORIAL (BEGINNER → ADVANCED)

 

🟢 1. BEGINNER LEVEL – Getting Started

📌 What is Excel?

Excel is a spreadsheet tool used for:

• Data entry
• Calculations
• Analysis
• Reporting

🧱 Excel Structure

• Workbook → Entire file
• Worksheet → Sheet inside workbook
• Cell → Intersection (e.g., A1)
• Row → Horizontal (1,2,3…)
• Column → Vertical (A,B,C…)

✍️ Entering Data

• Text → Names
• Numbers → Scores
• Dates → 16/04/2026

⚡ AutoFill (VERY IMPORTANT)

Drag the small square to:

• Continue numbers (1,2,3…)
• Copy formulas
• Fill dates

🟡 2. BASIC FORMULAS (FOUNDATION)

➕ Arithmetic

=A1 + B1
=A1 - B1
=A1 * B1
=A1 / B1

📊 Common Functions

=SUM(A1:A10)
=AVERAGE(A1:A10)
=MAX(A1:A10)
=MIN(A1:A10)
=COUNT(A1:A10)

🎯 Example Table

Item	Cost	Selling	Profit
Pen	50	100	=C2-B2

🟠 3. INTERMEDIATE LEVEL

🔀 IF Function (Decision Making)

=IF(A1>=50, "Pass", "Fail")

🔍 VLOOKUP (VERY POWERFUL)

=VLOOKUP(A2, A1:C10, 3, FALSE)

👉 Use it to:

• Find student results
• Retrieve prices
• Match records

🔗 CONCATENATION

=A1 & " " & B1

👉 Combine First Name + Last Name

🎨 Conditional Formatting

Highlight automatically:

• Fail scores (red)
• High scores (green)

🔵 4. DATA MANAGEMENT

🔽 Sorting

• A → Z
• Highest → Lowest

🔍 Filtering

Show only:

• Passed students
• Specific department

📌 Data Validation

Restrict input:

• Only numbers
• Dropdown list

🔴 5. ADVANCED LEVEL

🧮 Pivot Tables (🔥 VERY IMPORTANT)

👉 Used for:

• Summaries
• Reports
• Dashboards

Example:

• Total sales by department
• Student performance summary

📈 Charts

Types:

• Bar Chart
• Pie Chart
• Line Chart

👉 Convert data into visuals

🔁 Advanced Functions

INDEX + MATCH (Better than VLOOKUP)

=INDEX(C1:C10, MATCH(A2, A1:A10, 0))

COUNTIF / SUMIF

=COUNTIF(A1:A10, "Pass")
=SUMIF(A1:A10, "Pen", B1:B10)

⚙️ 6. AUTOMATION (ADVANCED)

🔹 Flash Fill

Auto-completes patterns

🔹 Macros (Intro)

• Record repetitive tasks
• Automate work

🔹 Power Query (Advanced Users)

• Clean large data
• Import data

🧑‍🏫 7. TEACHING FLOW (FOR YOUR CLASS)

🟢 Day 1:

• Excel Interface
• Data Entry
• AutoFill

🟡 Day 2:

• Formulas & Functions

🔵 Day 3:

• IF, VLOOKUP
• Data Validation

🔴 Day 4:

• Pivot Tables
• Charts

🎯 8. PRACTICAL CLASS WORK

✅ Task 1:

Create student result sheet:

• Name
• Score
• Grade (IF)

✅ Task 2:

Create business sheet:

• Cost price
• Selling price
• Profit/Loss

✅ Task 3:

Filter:

• Only students who passed

✅ Task 4:

Create chart for results💡 REAL-LIFE APPLICATION (VERY IMPORTANT)

You can use Excel for:

School results

• Financial records
• Attendance tracking
• Registry operations (very relevant to your training 🔥)

🚀 PRO TEACHING TIP (FOR YOU)

When teaching:
👉 Don’t explain too much
👉 Let them DO more practicals