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')
[workbook]

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

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

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

Power Query and Data Cleansing (53')
[workbook]

Pivot Table (53')
[workbooks]
[cheat sheet]

Converting columnar data to sortable rows (9')

Full Outer Join (6')

Seven steps to using macros and VBA (90')