The exact prompts and workflow from my Reel. Tell ChatGPT what you track, the KPIs you need, and the look you want. It builds the data structure, formulas, charts, and dashboard. You test it and own it.
A preview with sample numbers. The palette you pick here goes straight into the prompts below.
The prompts work in both. Pick the one that fits how you work.
Describe what you want and ChatGPT builds a downloadable .xlsx file for you. Fastest way to get a first version. It's generated with code, so interactive Excel features like slicers and PivotTables often don't come through; prompt 3 catches that.
ChatGPT for Excel works in a sidebar in your open workbook, writing live formulas and charts directly into the file. OpenAI says it's available on all ChatGPT plans. How to set it up.
Fill these in once and every prompt below updates as you type. Anything you leave blank stays as a highlighted placeholder you can edit inside ChatGPT.
What you track, the KPIs, and how it should look. Asking for the design first means you fix the structure in one reply, not after the whole file is built.
One row in the data table equals one real event (an order, an expense, a task). Every KPI has formula logic you can read. If a column or KPI is missing, say so now; it's free to change at this stage.
This is where your palette and style go in. Sample data lets you see the dashboard working before you trust it with real numbers.
The file opens without errors. Click any KPI on the dashboard and you see a formula like SUMIFS, not a typed number. The colors match what you picked.
The step most people skip
A template that breaks on row 51 isn't a template. Make ChatGPT prove the dashboard updates when new data arrives, and tell you what it couldn't build.
Type three new rows into the Data sheet, including one with a new category, and watch the KPIs and charts move. It takes two minutes, and it's what turns an AI file into your template.
Input cells that look different, formulas that can't be overwritten, and no scary errors on an empty sheet.
Someone who has never seen the file knows where to type within ten seconds. Try it on a colleague.