Excel Power Query

Overview

Power Query is a data connection technology that comes with Excel that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop. With Power Query you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports. This class is designed to teach Power Query from the ground up and assumes you have not used Power Query in the past. Once we have covered the foundational topics of Power Query, then we will move on to the Power Query M language (code) that is used to create queries in Power Query.

Price

$595 per Student

CPE Credits

8 CPE Credits

Who this course is for

New to Power Query or never been formally trained in Power Query
Users who utilize often the VLOOKUP and INDEX/MATCH Functions
People performing Data Analytics in Excel, Power Pivot, Power BI, Tableau, Python, R
Business Intelligence Specialists using Excel, Tableau, Power Pivot, Power BI, Python, R
Data Analysts / Financial Analysts using Excel, Tableau, Power Pivot, Power BI, Python, R
If you or your team needs to fetch data from different sources and transform it so that it can be used in Excel for further analysis, then this course will help you master Power Query features from scratch
IT specialists who performs Extract Transform & Load (ETL) activities for business

Duration

1 Day

Class Outline

Power Suite Overview

What is Power Pivot, Power Query, Power View and Power Map
The Power Suite Workflow
Power Query Examples
Power Pivot Examples
Power View Examples

Data Loading Options

Common Usage Patterns
Load to a Table
Load to a Pivot Table
Load to a Pivot Chart
Only Create Connection
Add to the Data Model

Standard Transformations

Basic Data Transformations
Text Data Transformations
Number Data Transformations
Date Data Transformations

Advanced Transformations

Indexes and Conditional Columns
Grouping and Summarizing Data
Transposing Data
Pivoting and UnPivoting Data

Merging, Appending, and Updating Queries

Updating Workbook Queries
Combining Multiple Queries
Appending Queries
Utilizing a Folder of Data Files

Custom Columns

Columns From Examples
Custom Columns

M Language and Advanced Query Editor Concepts

M Language Overview
Parameters in Power Query
Maintaining Parameters
Custom M Function Overview
Custom M Functions with Parameters
Custom M Functions using Advanced Editor

Query Organization and Dependencies

Grouping Queries
Query Dependency View

Excel Power Query Schedule

In-Person Classes Schedule

Date	Location	Price	Registration
February 7, 2025 9:15 AM to 5:00 PM	Austin, TX	$595.00	Register
April 4, 2025 9:15 AM to 5:00 PM	Austin, TX	$595.00	Register
May 30, 2025 9:15 AM to 5:00 PM	Austin, TX	$595.00	Register
July 25, 2025 9:15 AM to 5:00 PM	Austin, TX	$595.00	Register
September 19, 2025 9:15 AM to 5:00 PM	Austin, TX	$595.00	Register
November 14, 2025 9:15 AM to 5:00 PM	Austin, TX	$595.00	Register