Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
Download Zipped Folder with All Files: https://excelisfun.net/files/14-M365ExcelClassVideoFiles.zip This video teaches how to unpivot a cross tabulated table and convert it to a proper table so you can perform data analysis. This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW This video covers. 1. (00:00) Introduction and video topics 2. (00:25) What is a Cross Tabulated Table and What are Benefits of Converting to Proper Table? 3. (01:14) UnPivot feature in Power Query. 4. (01:52) Table.UnpivotOtherColumns M Code Function 5. (02:21) Sort with Resulting Table 6. (02:32) PivotTable from Resulting Table 7. (02:58) Video Summary and Conclusions 8. (03:12) 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/ #excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #datamodel #datamodeling, #unpivot #pivottables #Pivot