Welcome to the first video of my introductory series on Power Query, this fantastic Excel add-in! By taking you through different scenarios and the M language behind the scenes, my aim is to show you how Power Query is a game changing tool that will make you look like a “M”agician (…get it?) to your co-workers.
In this 1st scenario we’re going to reshape and transform a raw data table into something cleaner. I will show you how to connect Power Query to an Excel workbook and remove columns and rows. Enjoy the video, let’s begin 🙂