One user asked Copilot in Excel for a list of checks to run before sending a budget report. After the checks, a £4,000 duplicate invoice was zeroed out and the contractor total came to £52,400, matching the raw export.
Before I send this budget report, give me a checklist of the checks I should run on this workbook: duplicate entries, totals that don't match the raw data, missing or blank values, odd outliers and formula errors. For each check, tell me exactly where to look in this sheet and flag anything you find, but don't change any figures without asking me.
Replace the [PLACEHOLDERS] with your own details before you send it.
How to try it
- Open the workbook in Excel and keep the original raw export to hand.
- Ask Copilot the prompt and work through each check it lists.
- Fix anything it flags yourself, then reconcile the final totals against the raw export.
Why this works
Mistakes in reports usually come from duplicated rows, broken formulas or totals that drift from the raw data. A checklist of where to look makes the review systematic, and keeping the changes in your own hands means nothing is altered without you seeing it.
Tips for a better result
- Keep a copy of the original file before making any fixes.
- Ask for checks specific to your report, such as VAT or currency columns.
- Reconcile the final total against the raw export yourself.
- For more ways to work with spreadsheets, see our guide to learning Excel formulas with AI.
Common mistakes to avoid
- Letting it change figures without you reviewing them.
- Assuming no flags means the report is perfect.
- Sharing sensitive financial data outside approved work tools.
Try a variation
Here’s a variation of our own (not from the original source) to try next:
I've got this [MONTHLY REPORT] in Excel. Build me a reusable 'pre-send' checklist sheet with each check, where to look, a formula I could use to spot problems, and a column to tick it off. Don't change any existing data.
If this was useful, our AI for work and business hub has lots more in the same vein.
More work use cases
Rebuild an awkward inherited spreadsheet report with Copilot in Excel
Someone who inherited a report built on pivot tables, which was a pain to update because the pivots could move when refreshed, asked Copilot in Excel to redo it. Even with a rough, loosely worded request, Copilot worked out how to read the pivots and rebuilt the report on a separate tab, which they said came out flawlessly.
I've inherited this workbook. The report on the [SHEET NAME] tab is built from pivot tables on [SHEET NAMES], and it's hard to update because [WHAT GOES WRONG, E.G. THE PIVOTS MOVE WHEN I REFRESH]. Please rebuild the report on a new tab called [NEW TAB NAME] so it shows [WHAT THE REPORT NEEDS TO SHOW, E.G. MONTHLY TOTALS BY REGION AND PRODUCT]. Use formulas that update when the source data changes, keep the original tabs untouched, and list which cells and ranges you used so I can check the figures against the old report.
Catch up on work after a holiday with Copilot
A project manager working across Japan and the US used to lose a whole day catching up after holidays. Now he uses Copilot to sort email subjects by urgency, draft holding replies, summarise the decisions made while he was away and turn meeting transcripts into action lists, telling it to use only the information he provides.
I've just come back from [NUMBER] days off. Here are the subjects (or a summary) of the emails I missed: [PASTE]. Sort them into: needs my reply today, needs a decision from me, and just for information. Draft short holding replies for the urgent ones, and summarise the key decisions made while I was away in three bullet points. Use only the information I've given you and don't add anything.
Turn long work papers into an audio overview with Copilot
Faced with a pile of board papers, one user put them into a Copilot Notebook and created an audio overview to listen to while driving home, joking that it made them sound much more interesting than they really are.
(In a Copilot Notebook, with the documents added) Create an audio overview of these [BOARD PAPERS / REPORTS] for someone who has [TIME, E.G. 15 MINUTES] on the drive home. Focus on the decisions we're being asked to make, the key numbers and anything that has changed since [LAST MEETING]. End with three questions I might want to raise.
Reference: X @Cliffinkent