EN
Start unlimited
Catalog Courses Books Assets Newsletter Merch About Contact Blogs
Cart Sign in Start unlimited
Catalog / All levels / Beginners Excel Automation with Power Query and M Query Language
Mammoth Club All levels 7 sections 37 lectures

Beginners Excel Automation with Power Query and M Query Language

MC
Created by Team Mammoth
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.

7 sections · 37 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.

Buy lifetime access →