Download Excel File: https://excelisfun.net/files/EMT1857-1858.xlsx
Learn how to group in the GROUPBY and PIVOTBY functions to create Year by Month Sales Reports.
Topics:
1. (00:00) Introduction
2. (00:21) Shout Out to Excel Instructor: Radosław Poprawski at https://www.youtube.com/channel/UCVOcrn3Orn-aC0q1qGyQQmQ
3. (00:33) EOMONTH column, YEAR column inside HSTACK
4. (01:31) Custom Number Format for month
5. (01:42) GROUPBY
6. (02:17)PIVOTBY
7. (02:39) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp