All templates
Analysis
KPI Dashboard
Pull your key numbers onto one clean summary sheet.
Dashboard3 rows
| # | AMeasure | BThis month | CLast month | DChange | ETarget | FOn track? |
|---|---|---|---|---|---|---|
| 1 | Revenue | 24,100 | 21,850 | 10.3% | 23,000 | Yes |
| 2 | New customers | 18 | 22 | -18.2% | 20 | No |
| 3 | Avg order | 213 | 198 | 7.6% | 200 | Yes |
What it tracks
- Headline numbers
- Targets
- Trend against last month
Included sheets
DashboardDataTargets
Key calculations
- Change
- =IFERROR(B2/C2-1,0)
- On track?
- =IF(B2>=E2,"Yes","No")