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/16-M365ExcelClassVideoFiles.zip This video teaches how to use the Group By feature in Power Query. The 10 examples cover many helpful applications of how to use Group By for calculations and Data Analysis. Basics to Advanced Lessons. 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:32) What does Group By do? 3. (01:07) When to use Group By or other tools such as PivotTables 4. (01:44) Basics of Group By feature 5. (03:41) Table.Group M Code function 6. (04:29) How to Hack Group By dialog box to get the User Interface to write most of the M Code (Standard Deviation calculation) 7. (06:56) Type M Code for Group By Calculation (Unique List of SalesReps who Sold Product) 8. (09:52) Ranking in Power Query 9. (13:58) Group By: Two Conditions 10. (14:55) Sort by Multiple Columns (Different than in Excel) 11. (15:27) Sort a List 12. (16:33) Group By Back-To-Back: Frequency Distribution For Failed Student Classe Combination 13. (20:51) Group By: Add Blank Row After Each Group (Bill Szysz) 14. (21:50) Table Literal 15. (22:30) Join operator to append tables 16. (27:10) Group By 4th Argument: Consecutive Occurrences 17. (32:41) Video Summary and Conclusions 18. (33:23) 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, #mcode #mcoder #groupby #groupbyPowerQuery #powerQueryGroupBy