Intermediate Excel Automation with Power Query and M Query Language
01
Skill level
All levels
02
Sections
6
03
Lectures
22
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
6
Sections
✓
22
Lectures
✓
22
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.
+ 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
+ Build conditions with M if expressions 2 lectures
01 Build conditions with if expressions
Locked
Build conditions with M if expressions - Source Files
Locked
+ 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
+ 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
+ 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
+ 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
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.