First steps in Power Query for Excel

Power Query is a Microsoft extract, transform, and load (ETL) technology that enables users to access data from structured and unstructured sources, reshape it, and load it into Excel workbooks.

Analysts, researchers, and project managers want to build repeatable data cleaning processes on large datasets. Rather than write complex Excel formulas or programs in Visual Basic for Applications (VBA), these users can conduct their work in Power Query with no coding required.

The focus of this course will be using Power Query to transform tabular data sources into tables that are ready for data analysis. By the end of the course, users will be able to pivot, filter, and merge data so that it’s ready for analysis in Excel.

What you'll learn-and how you can apply it

By the end of this online course, you’ll understand:

• How Power Query serves as an ETL tool for Microsoft Excel

• What makes data “tidy,” and why tidiness is desirable for data analysis

• The role of the M programming language in Power Query

And you’ll be able to:

• Load data from Excel worksheets, workbooks and CSV files

• Perform common data wrangling tasks such as sorting, filtering, and aggregation

• Combine data from multiple sources using joins and appends

What you'll get

• Over 2.5 hours of video walkthroughs

• Demo notes: follow step-by-step along with the tutorials

• Drills: practice the concepts for yourself, then follow along with the solutions

• All datasets and solution files from the course

• Course slides