Excel GROUPBY & PIVOTBY: Formula-Driven Summary Reports
Summarise data with GROUPBY in one spilling formula, combine several values and functions, control totals and subtotals with total_depth, sort and filter inside the function, build cross-tabs with PIVOTBY, show shares with PERCENTOF, write your own LAMBDA aggregations and finish with a dynamic monthly report: 8 hands-on labs, graded instantly.
The first lesson is free — no account needed.
Lessons
- GROUPBY Basics: One Formula Instead of a Summary TableFree
- Several Values and Several Functions in One Report Pro
- Totals and Subtotals with total_depth Pro
- Sort and Filter Inside GROUPBY Pro
- PIVOTBY: Cross-Tabs with Rows and Columns Pro
- Shares of the Total with PERCENTOF Pro
- Your Own Aggregation with LAMBDA Pro
- Capstone: A Dynamic Monthly Report Template Pro