Advanced Excel · Interactive lesson 9 of 12
Dashboard design
A dashboard isn't every chart you could make — it's the handful of numbers one specific audience needs to make one specific decision, laid out so nothing competes for attention.
Screens shown: Excel for Microsoft 365 for Windows. Practice works in any browser.
Written tutorialDesigning an Excel DashboardSkill check
Try these first:
- Name the audience and the decision before picking a single chart.
- Pick 3–5 KPIs instead of showing everything available.
- Apply one consistent number format across every tile and chart.
- Explain what makes a dashboard feel cluttered, and how to fix it.
All familiar? Skip ahead to A10 — Audit, Controls & Error Checking.
Concept teach
What you're learning
- Audience and decision first
- "Who's looking at this, and what will they decide from it?" — answered before a single chart is built, not after.
- KPI selection
- Three to five numbers that matter, not every number available — more tiles usually means less gets read, not more gets known.
- Slicer / control placement
- Filters belong somewhere consistent — top or side, same spot every time — so a returning viewer never has to hunt for them.
- Chart choice
- A trend over time is a line, a comparison across categories is a bar, a share of a whole is (sparingly) a pie — matching the chart to the question, not the other way around.
- Consistent number formats
- Money looks like money everywhere on the page, percentages look like percentages everywhere — mismatched formats read as unfinished, even when the numbers are right.
- Status indicators
- A small color or icon that says "on track" versus "needs attention" at a glance — placed next to the number it describes, not in a legend three tiles away.
- Avoiding decorative clutter
- Gridlines, borders, 3-D effects, and extra colors that don't carry information are the first things to remove, not the last.
Where to find it in Excel
Insert›Charts · Slicer
| A | B | C | D | E | F | G | ||
|---|---|---|---|---|---|---|---|---|
| 1 | Sales | Margin | Orders | |||||
| 2 | $71.1K | 31.9% | 1,248 | |||||
| 3 | ▲ 6% vs LY | ▼ 0.8 pt | ▲ 112 | |||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 |
Swipe sideways to see the whole window.
- 1Three to five KPIs at the top, each with the same number format and a comparison.
- 2Match the chart to the question: Line for trends, Bar for ranking.
- 3Insert › Slicer adds a filter people can click; put controls in one place.
- 4Conditional formatting turns comparisons into status colors.
- 5View › untick Gridlines for a cleaner page.
Rendered view of Excel for Microsoft 365 (Windows). Ribbon layout can differ slightly on Mac, Excel for the web or a narrow window.
Guided build
Pick which KPI tiles belong on an executive sales dashboard, then filter the chart by region.
Independent extension
Design a one-page dashboard
Pick one real audience (your manager, a client, yourself next quarter) and build a one-page dashboard for them: revenue, margin, a trend, a regional or category split, and one filter control. Cut anything that doesn't serve that specific audience's decision.
Spot a mistake or have an idea for this lesson? Send feedback