Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/12-M365ExcelClassVideoFiles.zip
Full Free M Code Class from Basic to Advanced in Excel and Power BI Power Query taught by Excel MVP and Highline College Professor, Mike Girvin. Full Class: Microsoft 365 Excel Complete Story.
This video covers.
1. (00:00) Introduction
2. (00:26) Define M Code
3. (03:05) Power Query and M Code are in Both Excel and Power BI Desktop
4. (05:08) Advanced Editor button in Excel & Power BI Desktop
5. (05:39) Power BI Desktop “Enable Load”
6. (06:22) M Code Basics, tour of Power Query Editor and the three locations to view and change M Code. We use a Group By Query to learn about the basics of M Code.
7. (10:23) M Code Identifiers and spaces.
8. (14:21) let expression definition and structure.
9. (16:32) Expressions
10. (18:20) Insert or Delete Query (let expression) Steps: 2 possibilities.
11. (24:45) #shared to show Standard Library in Power Query
12. (26:32) Learn about 15 M Code Values: Null, Logical, Text, Number, Time, Date, DateTime, DateTimeZone, Duration, Table, Record, List, Binary, Function, Type
13. (33:15) IF function and AND Function in M Code
14. (36:23) Compare Excel Close & Load to Power BI Desktop Close & Apply
15. (38:45) Copy and Paste Tables into Power BI Desktop.
16. (39:35) Power Query Date and Duration Examples
17. (46:32) Table Values
18. (51:08) Record Values
19. (53:37) List Values
20. (59:05) Binary, Function and Type M Code Values
21. (59:40) Data Types
22. (59:40) Values Vs. Data Types
23. (01:01:38) M Code Lookup: Two-way Lookup, Column Lookup, Row (or Record) lookup. Also know as: Projection (lookup column) and Selection (lookup row)
24. (01:03:19) Diagrams for M Code Lookup
25. (01:06:04) Row Index Lookup
26. (01:07:15) Key Match Lookup
27. (01:08:55) Drill Down, Primary Keys and Lookup
28. (01:13:33) Custom Functions (5 examples to learn basics)
29. (01:17:50) Build reusable function.
30. (01:22:08) Build Custom Function as a Query Step.
31. (01:27:04) each and Underscore.
32. (01:29:47) Approximate Match Lookup M Code Custom Function (4 examples)
33. (01:39:13) Full Video Summary and Conclusions
34. (01:40:32) Closing and Video Links

Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/

ExcelIsFunFri, February 3, 2023 3:46pm