Excel Dashboard Tutorial

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:

If you are using normal cell references, that might be:

Step 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:

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.

Common dashboard mistakes

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.

Make the dashboard refreshable

Build the source data as a clean table with one header row, one record per row, and consistent data types. A PivotTable can summarize that table, but it is a snapshot until refreshed. After importing new rows or changing categories, refresh the PivotTable and inspect the KPI cards before sharing the dashboard.

Keep the source table, calculation layer, and dashboard view separate. The source table should hold raw records; helper columns can normalize statuses or dates; the dashboard should contain linked KPIs, PivotTables, PivotCharts, and only the filters people actually use. This makes it easier to find whether a wrong number came from the data, the calculation, or the presentation.

Use a short dashboard checklist: confirm the reporting period, refresh summaries, test each slicer or filter, scan for blank categories, and compare one headline total with the source table. A dashboard that looks polished but has stale pivots is less useful than a plain table with a trustworthy total.

Sources

• Microsoft Support: Create and share a dashboard with Excel
• Microsoft Support: Create a PivotTable to analyze worksheet data

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.