Download Excel START Files:
\nhttps:\/\/ift.tt\/2mifhh5
\nhttps:\/\/ift.tt\/2zEx2kt
\nhttps:\/\/ift.tt\/2mifhO7
\nDownload Excel FINISHED Files:
\nhttps:\/\/ift.tt\/2uxNo8v
\nDownload pdf Notes about Power Query: https:\/\/ift.tt\/2mifil9
\nAssigned Homework:
\nDownload Excel File with Homework:
\nAssigned Homework:
\n Download Excel File with Homework: https:\/\/ift.tt\/2zEx2Rv
\n Download Files to import for Merge Homework:
\n https:\/\/ift.tt\/2mhtsmP
\n https:\/\/ift.tt\/2zEx3ox
\n Example of Finished Homework:
\n https:\/\/ift.tt\/2mhttqT<\/p>\n
In this Video learn about three important Power Query Transformations: Merge, Append and UnPivot.
\nTopics:
\n1. (00:15) Introduction.
\n2. (02:00) Example1: Merge 2 Tables to Replace VLOOKUP or Relationship
\n3. (08:11) Example 2: Transform 3 Non-Uniform Sales Tables Then Append into Single Proper Data Set
\n4. (16:31) Example 3: UnPivot to Convert Cross Tabulated Data Tables into Proper Data Set
\n5. (22:29) Summary<\/p>\n
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.<\/p>\n