Data Transformation with Power Query in Microsoft Excel

What you’ll learn

First, you’ll explore connecting to many different sources of data including data in all shapes, sources, and sizes, and even learn to create custom connectors.

Next, you’ll discover how to transform data from things as simple as changing column names and data types to merging, sorting, aggregating, and pivoting data.

Finally, you’ll learn how to load your transformed data back into Excel.

When you’re finished with this course, you’ll have the skills and knowledge of using Power Query needed to successfully extract, transform, and load data right into Excel as well as gain a familiarity with Power Query that is transferable to the many other Microsoft products that are Power Query enabled.

Homepage