Excel: Power Query for Beginners

If any part of your job involves using Microsoft Excel, you’ve likely encountered disorganized or messy spreadsheets. Instead of feeling frustrated, use Power Query in Excel to import and clean data efficiently. In this course, Excel expert Dave Ludwig guides you through Power Query's robust features, showing you how to connect to data sources, filter data, and create conditional columns. Dave also highlights the significant cleansing capabilities of Power Query. Once your data is organized, you can easily create formulas, PivotTables, charts, and more.

Learning objectives
Describe what Power Query is and explain its importance in transforming data within Excel.
Identify the steps needed to import data from external files and refresh data when those files are updated.
Explain how to create visualizations and analyze cleaned data using charts and PivotTables.
Describe the most commonly used tasks to remove unnecessary columns from a dataset.