Microsoft Excel now offers GROUPBY and PIVOTBY aggregation functions, which make it easier to collect and organize data into compact summaries or tables. Plus, a new PERCENTOF function allows you to quickly return percentages from raw data. These functions are still in beta and are currently limited to Microsoft 365 Insider builds.
Microsoft Excel Has New Functions for Data Aggregation
The new GROUPBY, PIVOTBY, and PERCENTOF functions are currently exclusive to Insiders.
