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’s demonstration of the GROUPBY function is shown below.

Using the GROUPBY function in Microsoft Excel to split item sales into product categories with corresponding sales figures.

Microsoft

Excel’s newPIVOTBYfunction is extremely similar to GROUPBY, but it takes four arguments instead of three.

Total sales for each product category are also included.

Notice the use of the MAX function in this example.

Using the PIVOTBY function in Microsoft Excel to split item sales into categories, with each year of sales separated into columns.

Microsoft

Also, you could pull some pretty interesting tricks by fooling around with the new functions' full arguments.

There’s also the new PERCENTOF function.

(Technically speaking, PERCENTOF is logically equivalent to=SUM(data_subset)/SUM(data_all).)

Microsoft Excel’s new functions are currently limited to Microsoft 365 Insider builds.