Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

PIVOTBY & GROUPBY to Create Year by Month Sales Report. Grouping Trick! Excel Magic Trick 1859

Posted on by Annie D

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunMon, March 25, 2024 2:12pm