Your Cart
Loading

Clean the Mess: Excel + AI for Finance People — guide + 6 self-marking practice workbooks

On Sale
£12.99
£12.99
Added to cart

AI tools are now inside Excel, and they're usually right. On 2 November 2026 I ran six finance tasks through four of them — Claude and the free versions of ChatGPT, Copilot and Gemini. Twenty runs. Fifteen got the right answer, two of those only on a second try.

The other five are the reason this product exists.

Given a messy bank statement, the free Microsoft Copilot replied "Done." It said it had removed "duplicate transaction lines". One row was missing and money out was exactly £14.60 short — the amount of each of two genuine, identical Tesco purchases. It most likely deleted one as a "duplicate". Free Gemini's first answer to the same file was ten transactions that weren't in it at all. On a budget report, Copilot got every variance right, then opened its commentary with a profit figure £200 different from its own table.

None of them said anything was wrong with its data. The answers looked exactly like the right ones.

You can't tell which answer is wrong by reading it. You can only tell by checking it — the numbers and the words. This product teaches that check, and gives you the practice to make it a ten-minute habit.


What's inside

  • The guide (PDF, 27 pages). The nine-step check method, a data-safety chapter for real client and payroll data, a dated tools snapshot (ChatGPT for Excel, Claude for Excel, Copilot, Python in Excel), a prompt library and a one-page checklist.
  • Six practice workbooks (Excel), each with hidden traps and self-marking checks: clean a messy bank export · make a messy ledger export balance · reconcile the bank · reconcile a supplier statement · budget vs actual, with commentary · audit a workbook you inherited (five planted formula faults).
  • Spot the AI error — a five-minute challenge for you or your team.


How the workbooks work

Give your AI tool only the task's data file. Paste its answer into the yellow cells of your workbook. The Checks tab marks each line green (PASS) or red (FAIL) without displaying the expected figures. Fix until it's all green. The model answers, and the traps they explain, are in a separate Answers folder for when you're done — never give those to your AI.


Who it's for

Bookkeepers, accounts assistants, finance officers, management accountants and small-business owners who keep their own books. You need everyday Excel (SUM, filters, XLOOKUP or VLOOKUP). You don't need to know anything about AI.


What it isn't

Not a list of magic prompts. Not tax, legal or audit advice. Not endorsed by Microsoft, OpenAI, Anthropic, Google or any professional body. No promises about hours saved — it's about getting numbers right.


Safe to practise with

Every company, person and number in the workbooks is invented, so you can use them with any AI tool.


How this was made

Written with Claude (Anthropic's AI) under my direction. I set the method, ran every task myself in Excel, checked every answer, and I'm accountable for the content. — Ivan Soloviov


Requirements

Microsoft Excel 2013 or later, or Microsoft 365. AI add-ins inside Excel need Microsoft 365; with older Excel, use a chat assistant. Google Sheets is not supported.


Prefer Kindle or paper?

The same guide is on Amazon as a Kindle book, with a link at the back to download the six workbooks: https://www.amazon.co.uk/dp/B0HQHLM92F It's also out as a paperback on Amazon UK: https://www.amazon.co.uk/dp/B0HQP1RVMT


Recommend it, earn 30%

If you'd suggest this guide to colleagues, sign up as an affiliate: https://payhip.com/auth/register/af6ae8b76bd93bf - you earn 30% of each sale made through your link, paid monthly by UK bank transfer once you've earned £10 or more. Payouts are by UK bank transfer, not PayPal - email me your bank details. Affiliates, please don't review the book on Amazon (Amazon's rules).


Updates

Edition 2026.11. One refreshed edition (updated tools chapter) planned for May 2027, free to everyone who bought this edition.


Download and refunds

This is digital content you can download immediately. At checkout you'll be asked to agree to immediate access, which means you lose your 14-day right to cancel once the download starts. If a file is faulty or won't open, email me and I'll fix it or refund you. This doesn't affect your legal rights. Licence: one person — please don't share the files.


About the author

Ivan Soloviov has worked in finance since 1995, including many years leading a finance function.

You will get a ZIP (475KB) file