Digital SkillsProductivityPQ-101 100% HRDF claimable

Microsoft Power Query (Excel)

A practical course on extracting, transforming, and loading data from many sources directly into Excel. Learn to import and combine data from databases, files, and online sources, then clean and shape it for analysis — streamlining reporting and saving hours of manual prep.

1 DayPEOPLElogy

What you'll learn

Access data from different sources (SQL, CSV, Excel, JSON)
Clean and transform data with the Query Editor
Create calculated columns and custom transformations
Understand the M language and query syntax
Set data types and date/time formats
Pivot and unpivot columns for analysis-ready tables

Course modules (5)

01Get Data — sources and basic transformations

02Query Editor — structures and transformation pane

03Power Query syntax — data types, properties, steps

04Combine Queries — merge, append, folder loops

05Transformations — columns, rows, filtering, sorting