Skip to content

Learn online at your pace · pay in installments with M-PESA · verified certificates

+254 759 418 593
Self-paced Intermediate

Excel Power Query & Automation

A specialized, hands-on course focused on extracting, transforming, and automating data pipelines using Power Query and M code directly within Microsoft Excel.

4 Weeks Verified certificate

What you'll learn

  • ETL Pipeline Architecture: Connect to diverse data sources (Web, SQL, folder directories, CSV files) and design repeatable, automated data ingestion workflows.
  • Data Transformation & Cleansing: Clean messy text values, handle nulls, change data types, split/merge columns, and apply conditional cleaning rules using Power Query steps.
  • Advanced Merging & Appending: Combine multiple tables and bulk files from folders using relational merges, appends, and fuzzy matching techniques.
  • M Code Customization: Inspect, write, and modify custom M language expressions, custom columns, and conditional logic to handle advanced data manipulation tasks.
  • Automation & Refresh Workflows: Parameterize queries, establish background data refresh triggers, and build completely self-updating reporting systems.

Course content

The full curriculum is being finalised. Contact us for the syllabus.

About this course

Master the powerful ETL (Extract, Transform, Load) capabilities built into Microsoft Excel using Power Query. This course guides you through connecting to disparate data sources—such as SQL databases, web APIs, multiple CSV files, and folder directories—and automating complex data cleaning workflows. You will learn how to shape messy data, merge and append relational tables, unpivot columns, and write custom M code expressions. By the end of this course, you will completely eliminate manual copy-paste reporting routines and establish fully automated, self-refreshing data pipelines.

Tools you'll use

Microsoft Excel Power QueryPower Query EditorM Language (M Code)Excel Data ModelMicrosoft 365External Data Sources (SQLWeb APIsCSV/Excel files)

Learn anywhere

Phone, tablet or laptop. Pick up exactly where you left off.

Hands-on practice

Quizzes, coding exercises and projects marked by instructors.

Verified certificate

Each certificate has a code employers can verify online.

You might also like

Excel & Office Productivity

excel Essentials

A practical, beginner-friendly introduction to spreadsheet fundamentals, covering data entry, formatting, core formulas,...

4 Weeks Beginner Certificate

KES 3,000

or KES 900 to start

Excel & Office Productivity

Excel Intermediate

A practical course designed to elevate spreadsheet skills by mastering advanced lookup functions, conditional logic, Piv...

Beginner Certificate

KES 5,000

or KES 1,500 to start

Excel & Office Productivity

Excel Advanced Formulas & Functions

An advanced, formula-driven course mastering modern dynamic arrays, financial and statistical functions, nested computat...

4 Weeks Beginner Certificate

KES 10,000

or KES 3,000 to start

From

KES 6,000

Enrol now