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 Basics: Beginner’s Path to Data Transformation with 10 Exams
Mammoth Club All levels 25 sections 71 lectures

Excel Power Query Basics: Beginner’s Path to Data Transformation with 10 Exams

Power Query simplifies one of the hardest parts of analysis—cleaning messy data.

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

This course includes.

✓
25
Sections
✓
71
Lectures
✓
59
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.

15 sections · 61 lectures
+ 01 Course Overview 3 lectures
01 What Are Power Query And M Locked
02 Course Overview Locked
Source Files Locked
+ 02 Build your first M queries 3 lectures
01 Capitalize A Table Column Locked
02 Build An Expression With Let Locked
Source Files Locked
+ 03 Join tables with M 4 lectures
01 Build And Reference Tables Locked
02 Append And Combine Tables Locked
03 Inner Join Tables Locked
Join tables with M - Source Files Locked
+ 04 Build M functions to perform tasks 10 lectures
01 Build M Functions To Perform Tasks Locked
02 Call Functions Locked
03 Use The Each Keyword Locked
04 Change A Table With A Function Locked
05 Loop An Action With A Recursive Function Locked
06 Calculate Price After Discount 1 Locked
07 Use Optional Parameters To Combine Text Locked
08 Transform A List With A Function Locked
09 Calculate Number Of Working Days Locked
Build M functions to perform tasks - Source Files Locked
+ 05 Work with lists in M 5 lectures
01 Build A List With Each Locked
02 Concatenate Items In A List Locked
03 Iterate Over A List Locked
04 Iterate Over A List With Recursion Locked
Work with lists in M - Source Files Locked
+ 06 Build M variables to store data 5 lectures
01 Calculate Affiliate Revenue Locked
02 Variable Types Locked
03 Variable Scope - Where Can You Use Variables Locked
04 Order Of Evaluation Locked
Build M variables to store data - Source Files Locked
+ 07 Aggregate table data with M 7 lectures
01 Count Rows Locked
02 Calculate Profits Per Quarter Locked
03 Group Similar Rows Locked
04 Sort A Table Locked
05 Query Data From Another Spreadsheet Locked
06 Find Where Sales Met Quota Locked
Aggregate table data with M - Source Files Locked
+ 08 Work with tables in M 4 lectures
01 Build Tables Locked
02 Work With Tables Locked
03 Fill In A Table Locked
Work with tables in M - Source Files Locked
+ 09 Build conditions with M if expressions 2 lectures
01 Build Conditions With If Expressions Locked
Build conditions with M if expressions - Source Files Locked
+ 10 Work with M data types 4 lectures
01 Manipulate Text Locked
02 Work With Numbers Locked
03 Work With Date, Time And Duration Locked
Work with M data types - Source Files Locked
+ 11 Build queries for tables with M 3 lectures
01 Filter A Table By Row Locked
02 Format A List Of Values Into A Table Locked
Build queries for tables with M - Source Files Locked
+ 12 Build calculations for tables with M 5 lectures
01 Build Address Labels Locked
02 Calculate Percentage Of Total Locked
03 Calculate Sales Rank Locked
04 Count Number Of Distinct Rows Locked
Build calculations for tables with M - Source Files Locked
+ 13 Fetch data from the web with M 4 lectures
01 Query Tables From The Web Locked
02 Search For Links On The Web Locked
03 Check If A Webpage Exists Locked
Fetch data from various sources with M - Source Files Locked
+ Test Your Knowledge! 1 lecture
Practice Code Exam Locked
+ Challenge Your 10 FREE Practice Exams 1 lecture
Where to Find Your Exams Locked
Description

About this course.

This beginner’s course introduces Power Query in Excel, guiding you through the fundamentals of transforming raw data into analysis-ready form.


✅ Import and structure data from multiple sources

✅ Clean and reshape datasets for clarity

✅ Automate transformations to save time

✅ Reinforce practice with 10 structured exams


Power Query is beginner-friendly but powerful enough to handle real-world datasets.


🎁 Learn the essentials of transforming data directly in Excel. Human insight meets AI precision, editor review guarantees standards and interactive chat plus quizzes turn every tutorial into an engaging experience.

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?

Power Query simplifies one of the hardest parts of analysis—cleaning messy data.

Buy lifetime access →