Beginners Excel Automation with Power Query and M Query Language
01
Skill level
All levels
02
Sections
7
03
Lectures
37
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
7
Sections
✓
37
Lectures
✓
37
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.
+ Course Overview 3 lectures
01 What Are Power Query And M
Locked
02 Course Overview
Locked
Course Overview - Source Files
Locked
+ Build your first M queries 3 lectures
01 Capitalize A Table Column
Locked
02 Build An Expression With Let
Locked
Build your first M queries - Source Files
Locked
+ 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
+ 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
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
+ Work with lists in M 5 lectures
03 Iterate Over A List
Locked
01 Build A List With Each
Locked
02 Concatenate Items In A List
Locked
04 Iterate Over A List With Recursion
Locked
Work with lists in M - Source Files
Locked
+ 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
+ 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
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.