Capstone: a Combined Quarter Dashboard with a Chart
This lesson is part of the course
In this lesson
You combine three monthly files whose regions are in different orders into one Q3 table with lookups and a spilling XLOOKUP, total it and chart revenue by region and month.
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