Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Intermediate Excel Automation with Power Query and M Query Language
Work with tables in M
02 Work With Tables (5:37)
01 Build Tables (6:55)
03 Fill In A Table (3:27)
Work with tables in M - Source Files
Build conditions with M if expressions
01 Build Conditions With If Expressions (8:14)
Build conditions with M if expressions - Source Files
Work with M data types
01 Manipulate Text (11:34)
02 Work With Numbers (3:00)
03 Work With Date, Time And Duration (7:52)
Work with M data types - Source Files
Build queries for tables with M
01 Filter A Table By Row (6:59)
Build queries for tables with M - Source Files
02 Format A List Of Values Into A Table (7:57)
Build calculations for tables with M
01 Build Address Labels (8:26)
02 Calculate Percentage Of Total (6:44)
03 Calculate Sales Rank (7:04)
04 Count Number Of Distinct Rows (6:59)
Build calculations for tables with M - Source Files
Fetch data from the web with M
01 Query Tables From The Web (7:15)
02 Search For Links On The Web (8:09)
03 Check If A Webpage Exists (6:24)
Fetch data from various sources with M - Source Files
02 Work With Numbers
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock