Videos are all MP4 format.
Right-click and 'save as...' to download a copy,
or left-click to stream in your browser.

Workbooks are in ZIP format.


Installing Power Query (12')

Power Query pt.1 (24')
Overview, TRIM, format, flatten, parsing URLs


Power Query pt.2 (33')
Format using Formulas and Data Tools


Power Query pt.3 (17')
Consolidating multiple worksheets

Power Query and Data Cleansing (53')

Pivot Table (53')
[cheat sheet]

Converting columnar data to sortable rows (9')

Full Outer Join (6')

Seven steps to using macros and VBA (90')