Power Query – the first taste!

Intermediate functions in Power Query – An Intro

Intermediate: 6 essential functions from Power Query (Part 1)

Intermediate: 6 essential functions from Power Query (Part 2)

Advanced functions in Power Query – An Intro

Advanced – Stop dragging 12 month’s data 12 times!

Advanced – VLOOKUP() no more!

Advanced – Artificial Intelligence in Power Query!

Advanced – Finally the Instant Consolidation in Excel!

Takeaways

Segue to the next Course and Q&A

Course Reference Sheets