Excel Dashboard Tutorial
Learn how to build a clean Excel dashboard from structured data: KPIs, pivots, charts, filters, and review-ready layout.
Reviewed by Griddy
Updated for current Excel and Google Sheets workflows, with examples chosen to map back to real spreadsheet tasks rather than abstract formula syntax.
An Excel dashboard is a summary page that turns a structured data table into KPIs, charts, and review-ready views. The dashboard is only as good as the table underneath it. If the source data is inconsistent, the dashboard becomes decoration instead of a decision tool.
The practical approach is simple: clean the data, define the KPIs, build summaries, add charts, then format the dashboard so it can be scanned quickly.
Step-by-step Excel dashboard build
Step 1. Start with one clean source table
Put the raw data in a table with one header row and one record per row. Avoid merged cells, subtotals inside the data, and blank columns. For a sales dashboard, fields might include owner, stage, deal value, close date, probability, and source.
Step 2. Define the KPIs
Choose metrics that drive action. Examples:
- total revenue
- open pipeline
- weighted forecast
- deals closing this month
- overdue follow-ups
- average deal size
- win rate
For weighted forecast, use:
=DealValue*ProbabilityIf you are using normal cell references, that might be:
=D2*E2Step 3. Build summaries
Use pivot tables for grouped summaries like revenue by owner, pipeline by stage, or deals by source. Use formulas for specific KPI blocks.
For example, count overdue follow-ups:
=COUNTIFS(H:H, "<"&TODAY(), I:I, "<>Closed Won", I:I, "<>Closed Lost")Step 4. Add charts
Use charts that match the review question:
- bar chart for revenue by owner
- column chart for pipeline by stage
- line chart for monthly trend
- donut chart only when the category count is small
Keep chart titles direct. "Pipeline by Stage" is better than "Sales Performance Overview."
Step 5. Format for scanning
Put KPI cards at the top, charts in the middle, and detail tables below. Use consistent number formats, clear labels, and enough whitespace that the page does not look like a raw data dump.
✦ TIP
Common dashboard mistakes
| Mistake | Why it hurts | Fix |
|---|---|---|
| Too many charts | The dashboard becomes hard to scan | Keep only charts tied to decisions |
| Dirty source data | Pivots and formulas produce bad totals | Clean the table before building |
| Manual KPI numbers | Values drift from the source table | Link KPIs to formulas or pivots |
| No owner/status fields | The dashboard cannot drive action | Add fields that show accountability |
Templates help because they start with a clear data model. A sales pipeline template or project tracker gives the dashboard consistent columns from the beginning.
The Griddy way
The hard part of dashboards is not one formula or one chart. It is connecting cleanup, summaries, formatting, and layout without breaking the source data.
"Create a dashboard from this sales table with KPI totals, pipeline by stage, forecast by owner, and overdue follow-up count."
Griddy can create the formulas, charts, and dashboard layout from the data already in your sheet.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.
Use this on real templates
Start dashboards from structured operating sheets
Dashboards work best when the source table has clean fields for owners, statuses, dates, values, and the decisions people review weekly.
Sales Pipeline
Track deals by stage, owner, value, and next move in one lightweight pipeline sheet. Keep close dates, weighted forecast, and rep follow-ups visible without needing a full CRM.
Project Tracker
Track tasks, owners, priorities, due dates, and blockers in one delivery board. Group work by stream, review progress, and keep next steps visible.
CRM Lead Tracker
Track contacts, lead source, owner, next due date, and follow-up status in one lightweight CRM sheet. Keep hot opportunities and stale leads visible without paying for heavy sales software.
Small Business Budget
Plan revenue, direct costs, overhead, and EBITDA in one compact operating budget. Keep H1 totals, margin, and owner notes visible without building a giant finance model.