Excel Power Query Foundations
Stop rebuilding the same report every month
Set it up once. Next month, drop in the new file and click Refresh.
If you're tired of cleaning the same messy files, copying data between sheets, or rebuilding the same report every month, Power Query changes that.
It's a tool built right into Excel that most people never touch because they think it's technical. It's not. Let me show you what a difference this tool can make in your day-to-day.
Who it's for
Excel users who want to get started with Power Query the right way. No prior experience needed. If you've written an IF formula, you're ready.
2+ hours · 28 lessons · Exercise files included · Lifetime access
After Foundations, you'll be able to
Real skills you can use at work the same week.
✅ Clean messy data without touching it by hand
Blank rows, wrong data types, columns you don't need. Power Query fixes them in steps you can see and check.
✅ Combine tables without endless lookups
Bring data from different tables together, so you're not stacking VLOOKUPs to build one report.
✅ Refresh instead of redo
New file next month? Click Refresh. And when the source changes, you'll know how to handle it so nothing breaks.
✅ Catch errors before your manager does
Find and fix errors in your data, and understand what each step is doing. Even when AI wrote some of them.
Where Power Query takes you
Foundations is the first part of our full Master Excel Power Query - Beginner to Pro course. Here's what members of the full course shared with us.
"The course is very well structured and made it possible for me, as a 50-year-old non-digital native, to complete it after work and on weekends in less than a month. During the course I was already able to simplify some complex Excel sheets."
|
Jürg Hofer Head of Finance |
"No need to finish it before starting to benefit from it. As you move in the course, you discover a new way to streamline complex, time-consuming tasks. I've cut down the time to generate my monthly reports from 3-4 days to 2-3 hours."
|
Gustavo Jaramillo Senior Economic Analyst |
Course Curriculum
-
StartAnalyze Large Data Quickly! Pivot Table or Power Query? (5:41)
-
StartPower Query Overview: Import Large Data from Another File (12:14)
-
StartPower Query Editor & Basic Transformation (9:43)
-
StartQuick Insights on Data Quality & Distribution (Hidden Feature) (6:04)
-
StartFormula Bar, Applied Steps & M Code (6:58)
-
StartClose & Load Destinations (How to Change Them) (5:50)
-
StartRefresh Data & PQ Refresh Options (4:21)
-
StartImport CSV File & Extract Text Based on Pattern (7:18)
-
StartMerge Data with Another File (Pivot Table from Multiple Files) (7:56)
-
StartOld School Method: What if There Was NO Power Query? (4:14)
-
StartActivity: Get Familiar with PQ
-
StartUploading Data From Excel (8:17)
-
StartThe Hidden Table Method (Hidden Feature) (4:23)
-
StartHandling Changes to Source (10:14)
-
StartData Types (2:39)
-
StartData Types vs. Formatting & Null Values (4:21)
-
StartPower Query Navigation Shortcuts (Become Pro) (3:49)
-
StartFinding & Correcting Errors in Data (5:01)
-
StartMore Data Views: Duplicate OR Reference Query? (6:22)
-
StartKeeping an Eye on Query Dependencies (1:41)
-
StartDelete, Manage, Copy Queries & Backup Results (Become Pro) (4:04)
-
Start💪 CHALLENGE - Find and Correct the Mistake
-
Start🤔 QUIZ - Power Query Tips & Tricks
-
StartHelpful Power Query Settings
Your Instructor
My courses are for ambitious beginners and professionals who want to upgrade their data analysis skills. If you hate doing things manually, you'll love my approach.
I don't just want to show you solutions to specific problems. I want to teach you to find solutions to all your future ones.
Before founding XelPlus in 2015, I spent 15+ years as an economist, consultant and project manager, implementing and training users on systems like SAP BW and Oracle HFM. I have a Masters in Economics and I'm a ten-time Microsoft MVP.
My passion is teaching and solving difficult Excel problems. And I'm addicted to learning myself, so I get it.
Let's start now.