Excel: GROUPBY and PIVOTBY
(1 reviews)
by Alan Murray
Part of a series on 2024 Excel. The GROUPBY and PIVOTBY functions allow you to create PivotTable-style reports from a single formula. This short course explains how these two new functions can be used in conjunction with other functions.
£100+vat
1 CPD hours
120 days' access
Excel: GROUPBY and PIVOTBY
(1 review )
£100+vat
1 CPD hours
120 days' access
Use ACPD101 for 10% off any purchase.
This course will enable you to
About the course
With the GROUPBY and PIVOTBY functions, you can summarise and group data by any column(s) and provide an aggregation such as SUM, AVERAGE, MEDIAN, and even LAMBDA functions. There is also a new PERCENTOF function that can be used in collaboration with GROUPBY and PIVOTBY.
This module will get you ready to take advantage of some awesome new functions!
Look inside
Contents
How it works
Reviews
5
(1 review)
5
4
3
2
1
JS
Smith J
19 Nov 2025
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
JS
Smith J
19 Nov 2025
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
JS
Smith J
19 Nov 2025
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
Use ACPD101 for 10% off any purchase.