Excel Power Query and M Mastery: From Novice to Expert Excel Data Transformation
Created by Team Mammoth
01
Skill level
All levels
02
Sections
21
03
Lectures
99
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
21
Sections
✓
99
Lectures
✓
99
Resources
✓
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.
+ Beginners Excel Power Query and M Masterclass - Supercharge Data Transformation 3 lectures
Source Files
Locked
01 What Are Power Query And M
Locked
02 Course Overview
Locked
+ Build your first M queries 3 lectures
Source Files
Locked
01 Capitalize A Table Column
Locked
02 Build An Expression With Let
Locked
+ Join tables with M 4 lectures
02 Append And Combine Tables
Locked
03 Inner Join Tables
Locked
01 Build And Reference Tables
Locked
Source Files
Locked
+ Build M functions to perform tasks 10 lectures
03 Use The Each Keyword
Locked
02 Call Functions
Locked
01 Build M Functions To Perform Tasks
Locked
05 Loop An Action With A Recursive Function
Locked
04 Change A Table With A Function
Locked
08 Transform A List With A Function
Locked
07 Use Optional Parameters To Combine Text
Locked
06 Calculate Price After Discount
Locked
Source Files
Locked
09 Calculate Number Of Working Days
Locked
+ Work with lists in M 5 lectures
02 Concatenate Items In A List
Locked
03 Iterate Over A List
Locked
01 Build A List With Each
Locked
Source Files
Locked
04 Iterate Over A List With Recursion
Locked
+ Build M variables to store data 5 lectures
02 Variable Types
Locked
01 Calculate Affiliate Revenue
Locked
03 Variable Scope - Where Can You Use Variables
Locked
Source Files
Locked
04 Order Of Evaluation
Locked
+ Aggregate table data with M 7 lectures
02 Calculate Profits Per Quarter
Locked
03 Group Similar Rows
Locked
01 Count Rows
Locked
06 Find Where Sales Met Quota
Locked
04 Sort A Table
Locked
05 Query Data From Another Spreadsheet
Locked
Source Files
Locked
+ Work with tables in M 4 lectures
02 Work With Tables
Locked
03 Fill In A Table
Locked
01 Build Tables
Locked
Source Files
Locked
+ Build conditions with M if expressions 2 lectures
Source Files
Locked
01 Build Conditions With If Expressions
Locked
+ Work with M data types 4 lectures
02 Work With Numbers
Locked
03 Work With Date, Time And Duration
Locked
01 Manipulate Text
Locked
Source Files
Locked
+ Build queries for tables with M 3 lectures
02 Format A List Of Values Into A Table
Locked
01 Filter A Table By Row
Locked
Source Files
Locked
+ Build calculations for tables with M 5 lectures
02 Calculate Percentage Of Total
Locked
03 Calculate Sales Rank
Locked
01 Build Address Labels
Locked
Source Files
Locked
04 Count Number Of Distinct Rows
Locked
+ Fetch data from the web with M 4 lectures
03 Check If A Webpage Exists
Locked
01 Query Tables From The Web
Locked
02 Search For Links On The Web
Locked
Source Files
Locked
+ Advanced Excel Power Query and M Masterclass - Clean and Transform Data 3 lectures
Source Files
Locked
01 Advanced Excel Power Query And M
Locked
02 What Are Power Query And M
Locked
+ 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
Source Files
Locked
+ Build expressions with each 7 lectures
01 Work With The Each Keyword
Locked
03 Find An Entry In A Record
Locked
02 Generate A List
Locked
04 Select Items From A List
Locked
05 Serialize A Column
Locked
06 Find Best Match Of Values
Locked
Source Files
Locked
+ 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
Source Files
Locked
+ 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
06 Change Column Types
Locked
05 Join Tables On A Key
Locked
04 Cross Join Tables
Locked
Source Files
Locked
07 Fill A Table With Random Values
Locked
+ Pivot a table 3 lectures
01 What Is Pivoting
Locked
02 Pivot A Table
Locked
Source Files
Locked
+ Work with matrices in M 4 lectures
01 How To Multiply Matrices
Locked
02 Build Matrices In M
Locked
03 Multiply Matrics
Locked
Source Files
Locked
+ Build expressions with evaluate 4 lectures
01 Build An Expression With Evaluate
Locked
03 Use Global Library Functions
Locked
02 Build A Nested Evaluate Expression
Locked
Source Files
Locked
Instructors
Taught by people who ship.
Team Mammoth
Instructor
Produced by a team of Mammoth Club industry experts. Over 15 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.