Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
Master Your Data with Power Query
Course Content
Expand All
Platform Introduction
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Course Examples
Course Introduction
Who’s Ken
Extend Your Access
Pre-work – PivotTable Review
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Essential PivotTable Skills
The Trouble with Data
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Building Modern BI Solutions
The Trouble with Data
Classic Excel Cleanup
Power Query Adds ETL to Excel
Dealing with Data in Modern Excel
Power Query Basics
2 Lessons
Expand
Module Content
0% Complete
0/2 Steps
Importing a CSV File
Update Options
Appending Data
8 Lessons
Expand
Module Content
0% Complete
0/8 Steps
Basic Append Operations
Importing a Folder of Files – Overview
Importing a Folder of Files – Step 0
Importing a Folder of Files – Step 1
Importing a Folder of Files – Step 2
Importing a Folder of Files – Step 3
Importing a Folder of Files – Step 4
Update Options Revisited
Merging Data
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Merging Tables with Power Query
7 Ways to Join Your Data
Semi Joins
Cartesian Products
Merging with an Approximate Match
Reshaping Tabular Data
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Unpivot With Ease
Unpivot Subcategorized Tables
Pivoting Stacked Data
Pivoting Multi Column Vertical Pairs
Pivoting Multi Column Horizontal Pairs
Grouping Data
2 Lessons
Expand
Module Content
0% Complete
0/2 Steps
Data Grouping Recipe
Calculating Percentage of Total via Grouping
Conditional Logic
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Creating Conditional Logic
Conditional Logic – Advanced
Columns From Example
Performance
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Dealing with BIG Data – A Case Study
What is Query Folding?
How to Tell if Query Folding is Active
Awareness Topics
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Reusing Import Queries
Dynamic File Paths
The Impact of Power Query
Help Resources
6 Lessons
Expand
Module Content
0% Complete
0/6 Steps
Free Help Forums
Power Query Articles
Power Query Books
Power Query Recipes
Power Query Academy
Free Newsletters