Downloads:         
 

November 2024 Power Query Training

This link has download materials required for the course. Please extract from the zip file and keep in the structure provided. 

Files Zip

There is also a Power Query Guide available, which covers some of the exercises and other material.

PQ Guide

The videos used in the course are available in the links below:

Example 1 - Single CSV

Example 2 - Append Two CSVs

Example 3 - Files From Folder

Example 4 - Non-Standard CSV 

Example 5 - Merge and Group Variance Part 1

Example 6 - Merge and Group Variance Part 2

Example 7 - Data from the Web