Microsoft recently introduced two new functions for Excel: GROUPBY and PIVOTBY. While these new features offer exciting possibilities, they come with their own set of challenges. DOWNLOAD THE WORKBOOK ► [ Ссылка ]
NOTE: The PIVOTBY and GROUPBY functions are currently available on the Beta Channel for Microsoft365 subscribers. They might still be flighted, which means only a portion of users on beta will see the functions. They will eventually roll out to all beta users, then to the other channels.
🔗LINKS
🔎 Get free weekly Excel tips: [ Ссылка ]
💡 Free 60-minute Excel training session: [ Ссылка ]
📖 Join Our Comprehensive Excel Training Program: [ Ссылка ]
Related Content:
✅ Using Formulas When Pivot Tables Are a Better Option [ Ссылка ]
✅ 3 Amazing Tips For The Pivot Table Fields List [ Ссылка ]
✅ Excel’s Missing Feature: Slicers for PIVOTBY [ Ссылка ]
✅ Create A High Low Stock Pivot Chart In Excel [ Ссылка ]
✅ Refresh Pivot Tables Automatically with a Macro [ Ссылка ]
00:00 Introduction
00:57 Problem #1 Complexity
01:58 Problem #2 Formatting
04:30 Problem #3 Percent of Total
05:52 Problem #4 Pivot Charts Slicers
07:28 Problem #5 Flexibility
