Summarising the Combined Table with GROUPBY
This lesson is part of the course
In this lesson
You summarise the combined orders by region with GROUPBY, show each region's share with PERCENTOF, rank categories by average order and rebuild the summary with UNIQUE + SUMIFS for older Excel.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Stacking Regional Exports with VSTACK and DROP Locked
- Monthly Files into One Table: a Source Column with HSTACK Locked
- Merging Columns from Other Tables with XLOOKUP Locked
- Matching Keys: Missing Records in Both Directions Locked
- De-duplicating Combined Rows with UNIQUE Locked
- Summarising the Combined Table with GROUPBY Locked
- Reconciling Totals between Two Sources Locked
- Capstone: a Combined Quarter Dashboard with a Chart Locked