Limited time · 90% off Premium Membership - claim $199 deal →
For Teams For Libraries Sign in
EN
Start unlimited
Catalog Courses Books Assets Newsletter Merch About Contact Blogs
Cart Sign in Start unlimited
Catalog / All levels / Excel Power Query Pro: Advanced Data Cleaning & Transformation Mastery with 10 Exams
Mammoth Club All levels 20 sections 52 lectures

Excel Power Query Pro: Advanced Data Cleaning & Transformation Mastery with 10 Exams

Messy data is one of the biggest barriers to analysis—Power Query helps overcome it. This course shows how to leverage Excel’s Power Query tool to clean, shape, and transform datasets for reliable use in projects.

Created by John Bura
01
Skill level
All levels
02
Sections
20
03
Lectures
52
04
Instructor
John Bura
What's inside

This course includes.

✓
20
Sections
✓
52
Lectures
✓
40
Resources
✓
11
Quizzes
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content

Curriculum & lectures.

10 sections · 42 lectures
+ Test Your Knowledge! 1 lecture
Practice Code Exam Locked
+ Challenge Your 10 FREE Practice Exams 1 lecture
Where to Find Your Exams Locked
+ 00 Course overview 3 lectures
01 Course Overview - Advanced Excel Power Query And M Locked
02 What Are Power Query And M Locked
Course overview - Source Files Locked
+ 01 Build expressions with let 4 lectures
01 Build Nested Let Expressions Locked
02 Build A List With A Sequence Locked
03 Build An Unnamed Record Locked
Build expressions with let - Source Files Locked
+ 02 Build expressions with each 7 lectures
01 Work With The Each Keyword Locked
02 Generate A List Locked
03 Find An Entry In A Record Locked
04 Select Items From A List Locked
05 Serialize A Column Locked
06 Find Best Match Of Values Locked
Build expressions with each - Source Files Locked
+ 03 Build M functions to perform tasks 7 lectures
01 Build A Function Locked
02 Build A Closure Locked
03 Build A Function In A Record Locked
04 Count Fibonacci Numbers With A Recursive Function Locked
05 Remove HTML Tags Locked
06 Build A For Each Loop Locked
Build M functions to perform tasks - Source Files Locked
+ 04 Work with tables in M 8 lectures
01 Select A Column From A Table Locked
02 Select A Value At A Row And Column Locked
03 Select Row Where A Condition Is Met Locked
04 Cross Join Tables Locked
05 Join Tables On A Key Locked
06 Change Column Types Locked
07 Fill A Table With Random Values Locked
Work with tables in M - Source Files Locked
+ 05 Pivot a table 3 lectures
01 What Is Pivoting Locked
02 Pivot A Table Locked
Pivot a table - Source Files Locked
+ 06 Build expressions with evaluate 4 lectures
01 Build An Expression With Evaluate Locked
02 Build A Nested Evaluate Expression Locked
03 Use Global Library Functions Locked
Build expressions with evaluate - Source Files Locked
+ 07 Work with matrices in M 4 lectures
01 How To Multiply Matrices Locked
02 Build Matrices In M Locked
03 Multiply Matrics Locked
Work with matrices in M - Source Files Locked
Description

About this course.

✅ Import, merge, and restructure diverse datasets

✅ Automate repetitive cleaning steps to save time

✅ Create workflows that ensure accuracy and consistency

✅ Practice through 10 structured exams


Power Query’s intuitive interface makes advanced transformations approachable while maintaining transparency in every step. Tutorials authored by humans, enhanced with AI and perfected by human editors feature built-in chat help and dynamic quizzes designed to make knowledge stick.


🎁 Build the ability to turn raw data into analysis-ready information.

Instructors

Taught by people who ship.

John Bura

John Bura

Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.

Ready to start building?

Messy data is one of the biggest barriers to analysis—Power Query helps overcome it. This course shows how to leverage Excel’s Power Query tool to clean, shape, and transform datasets for reliable use in projects.

Buy lifetime access →