All Excel classes include
Free retake
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Small class sizes
Course recording
Power Query Course Online February 8, 2027
Power Query Course
$295.00
Learn Power Query for use in Excel and Power BI. In this hands-on course, discover how to connect data from files, folders, and the web, then clean, reshape, and combine it into analysis-ready tables that refresh with a single click. Build reusable queries that keep working as your data changes, load them into Excel reports or Power BI models. Understand when to use each tool.
Introduction to Power Query in Excel and Power BI
Understand what Power Query is, why it is the same engine in Excel and Power BI, and how it replaces manual, repetitive data preparation.
- What Power Query is and why it matters
- The data analysis process: extract, transform, load, and refresh
- One engine in two applications: what is the same and what is different
- Opening the Power Query Editor in Excel (Get & Transform) and in Power BI Desktop (Transform data)
- Navigating the Power Query Editor
- Power Query options and settings
- How Applied Steps record and replay your work
- Structuring source data for Power Query
- Refreshing queries
Connecting to Data Sources
Bring data in from the files and systems you already use, and keep the connection live for future refreshes.
- Importing from Excel workbooks and worksheets
- Importing CSV and text files
- Importing from a folder of files
- Importing tables from web pages
- Importing tables from PDF files
- Connecting to files stored in SharePoint and OneDrive
- Editing data source settings and changing file locations
- Connector differences between Excel and Power BI
Cleaning and Transforming Data
Fix the common problems in raw data so it is accurate and consistent before analysis.
- Setting and correcting data types
- Removing, renaming, and reordering columns
- Removing blank rows, errors, and duplicates
- Removing top and bottom rows
- Filtering and sorting rows
- Trimming, cleaning, and changing the case of text
- Splitting and merging columns
- Splitting columns into rows
- Replacing values and filling down blank cells
- Extracting text, dates, and parts of dates
- Math calculations on columns
- Date and duration calculations
- Adding conditional and custom columns
- Creating columns from examples
Reshaping Report-Style Data
Turn presentation-friendly reports into analysis-ready tables.
- Recognizing analysis-ready data versus report layouts
- Promoting and fixing column headers
- Removing subtotal and total rows
- Unpivoting columns into rows
- Pivoting rows into columns
- Transposing tables
- Summarizing data with Group By
- Grouping by dates and times
Combining Data from Multiple Sources
Bring related data together from multiple tables, files, and systems into a single, consistent table.
- Appending queries to stack similar tables
- Combining all files in a folder into one query
- Combining multiple sheets from a workbook
- Handling new or renamed columns in incoming files
- Merging queries to look up and join data
- Merging on multiple key columns
- Choosing join types: left outer, inner, full outer, and left and right anti joins
- Using fuzzy matching to merge inconsistent values
Building Reliable, Reusable Queries
Organize and troubleshoot queries so they keep working as data changes and can be maintained by others.
- Referencing vs. duplicating queries
- Staging queries and connection-only loads
- Viewing query dependencies
- Organizing queries into groups
- Deleting queries
- Using data profiling to check column quality and distribution
- Finding and fixing errors that break a refresh
- Creating parameters for file paths and filter values
- Reading and editing M code in the formula bar and Advanced Editor
- Creating a date table with Power Query
- Query folding basics for database sources
Power Query in Excel
Put queries to work in Excel with the right load and refresh settings, refreshable reports, and Copilot in Excel.
- Load options: table, PivotTable, connection only, and data model
- Refresh options: refresh on open, background refresh, and timed refresh
- Building a refreshable PivotTable report with slicers
- Exploring query results with Copilot in Excel
- Reviewing and validating AI-generated results
- Sharing workbooks that contain queries
Power Query in Power BI
Put queries to work in Power BI, from loading the model to publishing and scheduled refresh, and learn how to move work between Excel and Power BI.
- Loading queries into the Power BI model
- Enable load and include in report refresh settings
- Building a quick report from query output
- Publishing to the Power BI Service and scheduling refresh
- When a gateway is needed for on-premises data
- Power Query Online and dataflows: an overview
- Moving queries from Excel to Power BI
- Choosing when to use Excel, Power BI, or both
Why Excel classes at AGI are the best option for you
- Hands-on learning: Learn Excel quickly with our proven teaching methods.
- Exceptional curriculum: AGI has delivered Excel training to thousands over 25 years.
- Expert instructors: Our instructors are Excel experts and skilled educators.
- Small class sizes: Receive personalized attention with 10 or fewer participants per class.
- Repeat for Free: If you need a refresher or miss a class day, retake the Excel class at no cost.
