Copilot#data analysisStandard promptSaves ~15min
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.
rach_maeve4 June 2026
Fill in the Template
0 / 6 filledYour Built Prompt
Updates live as you typeI know the KPIs I want but I do not know exactly how to calculate them from the data I have.
In Excel, open the workbook with your raw data table and open Copilot.
Sheet and table: {{sheet_table}}
The columns I actually have: {{columns}}
The KPIs I want to calculate: {{kpis_wanted}}
What this calculation is FOR: {{purpose}}
Time period: {{period}}
Caveats my industry has (e.g. AHRPA, regulated, refund window): {{caveats}}
Ask Copilot:
For each KPI in {{kpis_wanted}}:
1. State the definition I should use, in plain English, given my data and caveats.
2. Write the exact Excel formula or DAX measure to compute it, with absolute references.
3. Show the formula working on the first row as a sanity check.
4. Note 2 ways the number could mislead me, and what to look at alongside it.
5. Suggest a sensible benchmark (with the source) so I know what good looks like.
If a KPI cannot be calculated from {{columns}}, say so plainly and tell me the one column I would need to add to make it possible.
AU English. AUD. AU FY where relevant.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
Excel formula generator from plain English
Describe what you want in plain English and get the exact Excel formula plus a walk-through.
Copy
Copilot
#data analysis
Pivot table builder from raw data
Turn raw Excel data into a pivot table with the right rows, columns, values, and filters.
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