Excel Power Query and M Mastery: From Novice to Expert Excel Data Transformation
Created by Team Mammoth
·
99 lectures
01
Skill level
All levels
02
Sections
21
03
Lectures
99
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
21
Sections
✓
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 Preview
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 14 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.