Course Labs
Work through each lab in order. Download the lab file, follow the steps, and complete the exercise before moving on.
01
Lab 01
Importing & Cleaning CSV Data
Import a CSV file, navigate the Power Query Editor, and reshape raw data into a clean table.
02
Lab 02
Duplicating Queries & Source Files
Reuse an existing query by duplicating it, redirecting the source, and managing auto-created steps.
03
Lab 03
Parsing Dates & Regional Settings
Use the Parse function instead of Change Type to safely convert date columns without misinterpreting values.
04
Lab 04
Fill Down, Pivot Column & Custom Columns
Fix blank-vs-null grouped headers, pivot row values into columns, and extract year from a date.
05
Lab 05
Futureproof Column Selection
Learn why Remove Other Columns is safer than Remove Columns when source files change shape over time.
06
Lab 06
Split Column by Delimiter
Expand multi-value cells into rows, fix double-delimiter blank rows, and insert steps mid-query.
07
Lab 07
Aggregate Columns & Group by Month
Sum multiple sales columns into one, then use Start of Month and Group By to produce monthly totals.
08
Lab 08
Merge Queries — The Power Query VLOOKUP
Join two queries using a shared key column with a Left Outer join and selectively expand matched columns.
09
Lab 09
Column Arithmetic & Formula Bar Renaming
Multiply columns to derive margin dollars and rename columns directly in the formula bar to keep Applied Steps lean.
★
Capstone · Part 1
Loading Multiple Data Types
Import data from Excel, a plain text file, and a PDF — then clean and shape each one for analysis.
★
Capstone · Part 2
Data Quality & Cleaning
Fix errors, handle missing values, remove duplicates, and correct out-of-range outliers in a patient satisfaction dataset.
★
Capstone · Part 3
Transformations & Analysis
Apply text transforms, calculate age between dates, derive numeric columns, and transpose a census dataset for pivot analysis.