At Last! Microsoft have FINALLY brought Power Query to the Mac platform. It’s not as fully-featured as its Windows counterpart but it’s a great start and to celebrate I delivered a live training session covering most of the key aspects of using Power Query on a Mac

Links to the video and individual sections below


What is Power Query?

Importing Data

Refreshing Data

Using the Query Editor to Clean Data

Creating Calculated Columns


Append Queries

Merge Queries