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
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.
Help me write a resignation letter to [MANAGER'S NAME] at [COMPANY]. My role is [JOB TITLE], my last day will be [DATE] in line with my [NOTICE PERIOD], and I'm leaving to [REASON, OR KEEP IT VAGUE]. Keep it short, positive and professional, thank them for [SOMETHING SPECIFIC] and offer to help with the handover.
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.
I'm planning a [LENGTH, E.G. TWO-DAY] retreat for [NUMBER] people from [TEAM OR GROUP]. Our goals are [GOALS]. Constraints: budget of [AMOUNT], dates [DATES], travel from [WHERE PEOPLE ARE BASED], plus [ACCESSIBILITY, DIETARY OR OTHER NEEDS]. Here are the options I'm considering: [PASTE VENUES OR LOCATIONS WITH KEY DETAILS]. Compare them in a table against the goals and constraints, explain the main trade-off with each, and recommend one with your reasons. Then draft an hour-by-hour itinerary for the recommended option.
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.
Here's a job advert: [PASTE ADVERT]. And here's my CV: [PASTE CV]. List the main skills and key words the employer is looking for, which ones my CV already shows, and which ones are missing or not clear enough. Don't invent experience; suggest where my real experience could be described more clearly. Then add this application to my tracker table: company, role, date, stage, notes.
Reference: X @Cliffinkent