Man sitting at table with laptop.

New aggregation functions in Excel: GROUPBY and PIVOTBY

Feature deep dive

Learn how to perform data aggregations using two new functions with just 3 arguments - the same number as a simple XLOOKUP.