From the course: Excel: Power Query (Get & Transform)

Make your data useful with Power Query - Microsoft Excel Tutorial

From the course: Excel: Power Query (Get & Transform)

Make your data useful with Power Query

If you have to clean data, sweep it all into one place, or compare data sets, you are going to want to know Power Query. Learn it so that it can help you simplify and even automate tasks in Excel, but without the complex formulas of VBA code. In this course, you're going to learn about things like Unpivot, anti joins, appending. It's going to be wild. Even if you're a beginner, there's a lot that Power Query can help you with. Put on your hat, come with me, and join me in this wondrous world that we call Power Query.

Contents