Download Excel START Files:
Excel Start: people.highlin...
Zipped Folder: people.highlin...
Download Excel FINISHED Files: people.highlin...
Download pdf Notes about Power Query: people.highlin...
Assigned Homework - these are problems for you to practice your new M Code skills:
Download Excel File with Homework: people.highlin...
Example of Finished Homework: people.highlin...
In this Video learn the basics of M Code, the computer language behind queries in Power Query.
Topics:
1. (00:15) Introduction
2. (03:46) Edit M Code: Applied Steps
3. (03:46) Edit M Code: Formula Bar
4. (03:46) Edit M Code: Advanced Editor
5. (09:50) Expressions
6. (09:50) let expressions
7. (17:34) Comments in M Code
8. (21:11) Values: Primitive, List, Record, Table, Function
9. (30:45) Lookup or Projection and Selection. Learn about Row Index Lookup and Key Match lookup
10. (42:50) Primary Keys, including Table.AddKey function.
11. (50:20) Custom Functions
12. (57:44) Parameter Queries
13. (01:02:27) Underscore Character _
14. (01:06:17) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
8 сен 2024