Run checks on a budget report before you send it with Copilot in Excel

← All use cases / Work

ToolMicrosoft Copilot

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.

Prompt to copy
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

  1. Open the workbook in Excel and keep the original raw export to hand.
  2. Ask Copilot the prompt and work through each check it lists.
  3. 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

Draft a resignation letter you’re happy with using Copilot

Ready to leave corporate life, one employee says Microsoft Copilot helped her draft the perfect resignation letter, something she'd never expected to use it for.

Full guide →

Plan a retreat by weighing up the options with Microsoft Copilot

One planner used Microsoft 365 Copilot to plan a retreat, not to book it, but to compare the options, weigh up the trade-offs, apply their constraints and organise a complete itinerary. They found the most useful part wasn't the writing; it was having help to think the decision through.

Full guide →
Source: X @gbrim

Turn your job search into a tracker you can learn from with Claude

A recent master's graduate used Claude like a career coach: she pasted job adverts next to her CV to see which key words she was missing, built separate CVs for three kinds of role, and tracked 186 applications through to one offer. Seeing it as a funnel made rejections feel less personal and showed her what to improve.

Full guide →

Reference: X @Cliffinkent