Download Excel START Files: https:\/\/ift.tt\/2L7OwpO
\nDownload Excel FINISHED Files: https:\/\/ift.tt\/2MsL7Hs
\nDownload pdf Notes about Power Query: https:\/\/ift.tt\/2wkNW2K
\nAssigned Homework:
\n Download Excel File with Homework: https:\/\/ift.tt\/2MmtxFf
\n Example of Finished Homework: https:\/\/ift.tt\/2L7OxtS<\/p>\n
In this Video learn the basics of M Code, the computer language behind queries in Power Query.
\nTopics:
\n1. (00:15) Introduction
\n2. (03:46) Edit M Code: Applied Steps
\n3. (03:46) Edit M Code: Formula Bar
\n4. (03:46) Edit M Code: Advanced Editor
\n5. (09:50) Expressions
\n6. (09:50) let expressions
\n7. (17:34) Comments in M Code
\n8. (21:11) Values: Primitive, List, Record, Table, Function
\n9. (30:45) Lookup or Projection and Selection. Learn about Row Index Lookup and Key Match lookup
\n10. (42:50) Primary Keys
\n11. (50:20) Custom Functions
\n12. (57:44) Parmenter Queries
\n13. (01;02:27) Underscore Character _
\n14. (01:06:17) Summary
\nComprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.<\/p>\n