ExcelPowerQueryTutorial

Public repository for files related to Dave Langer's "Excel Power Query for Advanced Analytics" YouTube tutorial series.

Content

What is Excel Power Query AND Why it Matters to You! (Part 1)

• Video

Excel Power Query Tutorial - Add Column From Examples (Part 2)

• Video
• Excel file

Excel Power Query Tutorial - Add Custom Column 1 (Part 3)

• Video
• Excel file

Excel Power Query Tutorial - Add Conditional Column (Part 4)

• Video
• Excel file

Excel Power Query Tutorial - Grouping Tables of Data (Part 5)

• Video
• Excel file

Excel Power Query Tutorial - Transforming Nested Tables (Part 6)

• Video
• Excel file

Excel Power Query Tutorial - Merging Tables (Part 7)

• Video
• Excel file