KPI Cards & Executive Dashboards: Assembling a Leadership View with AI in Excel

KPI cards are single-metric tiles (like "Revenue: $1.2M, ▲ 8%") and an executive dashboard is the page that arranges them with charts for a quick leadership view. This tutorial shows how to build both with AI help.

Table of Contents

• What Is a KPI Card
• Building KPI Cards in Excel
• Asking Copilot to Build KPI Cards
• What Is an Executive Dashboard
• Assembling the Dashboard
• Using ChatGPT to Design the Layout
• Best Practices

What Is a KPI Card

A KPI (Key Performance Indicator) card is a small visual tile showing one important number plus context — usually a comparison to a target or previous period. Think "Monthly Sales: $48K, up 12% vs last month."

Building KPI Cards in Excel

A simple card is a formatted cell with a formula:

="Sales: $" & TEXT(SUM(B2:B100),"#,##0") & ", up " & TEXT((SUM(B2:B100)-SUM(C2:C100))/SUM(C2:C100),"0%") & " vs last month"

Pair it with a colored shape or a tiny sparkline (Insert → Sparklines) to show recent movement in one cell.

Asking Copilot to Build KPI Cards

Select your data and prompt:

Create KPI cards for Total Sales, Average Order Value,
and Growth Rate, with a comparison to last month.

Copilot generates cards with the metrics and deltas, which you then arrange across the top of your sheet.

What Is an Executive Dashboard

An executive dashboard is a single screen that combines KPI cards with a few charts (trend line, bar breakdown, maybe a heat map) so a leader understands performance in seconds. It is the output of everything in the earlier tutorials.

Assembling the Dashboard

1. Place 3–5 KPI cards across the top.
2. Add a trend line (from Tutorial 3) below them.
3. Add a bar or heat map (Tutorials 2 and 4) for breakdown.
4. Use Insert → PivotChart or Copilot charts so everything stays linked to the source table.

Keep it to one screen — scroll means it's a report, not a dashboard.

Using ChatGPT to Design the Layout

When stuck on arrangement, ask ChatGPT:

I have KPIs for sales, churn, and growth, plus a 12-month
trend and a region breakdown. How should I lay these out
on one Excel dashboard screen?

It returns a grid plan (cards on top, trend left, breakdown right) you can replicate with merged cells and chart placement.

Best Practices

• Limit to 5 KPIs — more than that and none get attention.
• Make every card answer "so what?" with a delta or target.
• Use consistent colors: green = good, red = bad, across all cards.