Task 1 of 8
Make a dropdown list of months in F1, using H2:H7 as the source, and pick "March".
Lesson theory
The task: build a dashboard for a manager on one sheet: a month selector, KPI cards, the half-year trend, and the breakdown by city.
How a dashboard works in Excel:
- the filter is a cell with a dropdown list of months (Data › Data Validation › List);
- the KPIs are formulas that point at that cell:
SUMIF,COUNTIF,SUMIFS. Pick another month and everything recalculates; - the charts are built from small summary tables, not from the raw log.
The deal log is A1:C20. Do the tasks in order.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.