All courses

Specialist · Data cleaning

Power Query

Build repeatable data pipelines that clean and combine messy files, then refresh them every month in one click.

New course(0 reviews) 6 modules · 43 lessons 7 knowledge checks About 2 hours of guided learning
View pricing

What you’ll learn

  • Import data from tables, CSVs, workbooks and folders
  • Clean and reshape data with applied steps instead of formulas
  • Append, merge and combine many files into one refreshable table
  • Use parameters and basic M code
  • Build a Data Model with relationships and simple DAX measures

Course overview

Power Query turns hours of copy, paste and clean-up into a single click on Refresh. You'll import data from tables, CSV files, workbooks and whole folders, then clean and reshape it with applied steps instead of fragile formulas.

From there you'll append and merge tables, combine many files into one, use parameters and basic M code, and load the results into the Data Model with relationships and simple DAX measures. Because Power Query lives in desktop Excel, each lesson is an interactive step-by-step guide with a companion practice file to follow along on your own computer.

How you’ll learn

Step-by-step guides

Interactive walkthroughs with before-and-after previews, plus a companion practice file for every lesson in desktop Excel.

Check your understanding

Short knowledge checks every few lessons confirm each technique has clicked before you move on.

Help when you're stuck

Owl, your AI tutor, sees exactly what's on your sheet. Members can also message Kyle directly through 'Ask Kyle'.

Your course project

Northstar Solutions: Branch Data Pipeline

Northstar's five branches each send a messy monthly export. You'll build a refreshable pipeline that combines every file in a folder, cleans and reshapes the data, merges it with the product list, and loads it into the Data Model — so next month's report is just a click on Refresh.

Every course in the academy works with the same company, so each project builds on the skills, and the data, from the last.

Course content

6 modules · 43 lessons · 7 knowledge checks
  • Interactive lesson
  • Step-by-step guide
  • Knowledge check

Where this course fits

A specialist course you can take any time after the recommended core level.

  1. Level 1Excel Foundations
  2. Level 2Essential Formulas & Everyday Logic
  3. Level 3Intermediate Lookups & Data SummariesRecommended first
  4. Level 4Advanced Dynamic Arrays & Logic
  5. Level 5Expert Techniques & Workbook Architecture

Before you start

Level 3: Intermediate Lookups & Data Summaries (Level 4's 'A Taste of Power Query' is a helpful head start). Requires desktop Excel.

Who this course is for

  • Anyone who cleans or combines the same exports every month
  • People who work with data from several files or systems
  • Analysts ready to go beyond formulas for data preparation

Meet your instructor

Kyle Stott

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade, consulting on and teaching best practices to over 400 companies across 30+ countries.

He built My Excel Academy so learners can practice in the same window they are learning in, with instant checks alongside an AI tutor, all while offering 1-on-1 instructor support when something doesn't add up.

Student reviews New course

This course doesn’t have reviews yet. Here’s what students say about the academy — rated 5.0 out of 5 across 3 reviews.

“My experience with My Excel Academy was excellent! The instructor was knowledgeable, engaging and provided plenty of hands-on practice. The course was perfect for beginners as it clearly outlined the workspace as well as some basic features that excel has to offer. I highly recommend this course for anyone looking to improve their excel skills or to begin their journey of learning excel.”
MarioMicrosoft Excel – Overview · April 21, 2023
“Really enjoyed this course! Packed full of useful insights. Even though I consider myself somewhat experience with Excel, I still took away new learnings.”
JackMicrosoft Excel – Overview · April 14, 2023
“I really appreciate the refresher of key basics. I use Excel daily and learned new tools, lingo and strategies. It’s tempting to skip past these foundational elements to tackle the sticky and more complex problems. With these basics in hand I’ll have a much easier time navigating the system and bringing efficiency to my work! Time to customize my Quick Access Toolbar!”
AleksandraMicrosoft Excel – Overview · April 13, 2023