Advanced Excel · Intermediate level

Intermediate level · Module 1 of 6 · 16 guided hours

Power Query for Data Preparation

Replace manual copy-and-paste with Power Query: import, clean, reshape and combine data in repeatable, refreshable steps.

Learning objectives

  • Import data from files and folders with Power Query
  • Clean and reshape data with applied steps
  • Combine tables with append and merge, and parameterise queries

Topics

  • Get & Transform
  • applied steps
  • data types
  • unpivoting
  • append and merge
  • folder imports
  • parameters and refresh

Lessons

  1. Lesson 1 Importing and Cleaning with Power Query

    Import data into Power Query and clean it with recorded, repeatable steps.

    Power Query Editorapplied stepsdata typesremove and fill

  2. Lesson 2 Reshaping and Combining Data

    Unpivot wide tables, append monthly files and merge related tables.

    unpivotappendmerge (join)join kinds

  3. Lesson 3 Folder Imports and Parameters

    Import every file in a folder automatically and make queries flexible with parameters.

    From Foldercombine filesparametersrefresh and error handling

Practical activity

Build queries that import twelve monthly branch files from a folder, clean them, combine them with a branch table and load one tidy table for reporting.

Expected outcomes

  • Repeatable data preparation
  • Hours of monthly manual work removed

Assessment

Practical: build a folder query from messy files; marked by correct output after a new file is added and refreshed.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.