Copilot#data analysisStandard promptSaves ~15min
Build a one-page Excel dashboard from raw data
Copilot turns a raw Excel data export into a clean one-page dashboard with key number tiles, mini trend charts, one breakdown, and a 50-word summary in your brand voice.
rach_maeve4 June 2026
Fill in the Template
0 / 7 filledYour Built Prompt
Updates live as you typeI have a raw data table in Excel and I want a single dashboard sheet I can send to a stakeholder.
In Excel, open the workbook with the raw data and open Copilot.
Sheet and table: {{sheet_table}}
Who the dashboard is for: {{audience}}
The decision it supports: {{decision}}
The 4 to 6 KPIs that matter: {{kpis}}
Time period: {{period}}
Comparisons that matter (vs. last month, vs. budget, vs. last year): {{comparisons}}
Brand colour I want as the accent: {{colour}}
Ask Copilot:
Build a dashboard on a new sheet called "Dashboard". It should fit on one printed A4 landscape page and include:
1. **Header strip** - title, period, last updated.
2. **KPI tiles** (one per KPI in {{kpis}}) - current value, change vs. {{comparisons}}, sparkline.
3. **One trend chart** - the most important KPI over {{period}}, with a clear annotation on any inflection point.
4. **One breakdown chart** - segmented by the dimension that matters most for {{decision}}.
5. **A short text block** (50 words) - what changed and what to do about it.
Use {{colour}} as the only accent colour, neutral greys for everything else. No emojis. No 3D charts. AU English. AUD. DD/MM/YYYY.
After the dashboard, give me one line on the most important question {{audience}} will likely ask, and where on the dashboard the answer sits.Run in
Fill in the required fields above to copy or run this prompt.
Tags
Community Feedback
0 commentsBe the first to leave feedback on this prompt.
Related Prompts
More in Data AnalysisClaude
#data analysis
Commission forecast from listings under contract
Reads your pipeline of listings under contract and forecasts the next 90 days of commission income, with risk ratings on each settlement.
Copy
Copilot
#data analysis
Find the right numbers to track in Excel for my business
Copilot explains each number in plain English, writes the exact Excel formula, sanity-checks it on row one, and flags 2 ways the number could mislead you.
Copy
Copilot
#data analysis
Excel formula generator from plain English
Describe what you want in plain English and get the exact Excel formula plus a walk-through.
Copy
Claude
#data analysis
Sales report by SKU
Ranks products by units sold, revenue, margin, and stock health for the period you pick. Tells you what to push and what to wind down.
Copy