The Excel AI Prompt Book

Ask an AI for an Excel formula and you get something that almost works.

It looks right. It uses real functions. It returns #VALUE! - or worse, it returns a number that's wrong.

That happens for five specific reasons, and this book opens by explaining all of them. The AI doesn't know your Excel version, so it hands you XLOOKUP when you're on Excel 2016. It doesn't know your layout, so it references the wrong cells. It assumes your data is clean. It doesn't know whether you want a formula, a spilled array, or a Power Query step. And it guesses with total confidence.

370 prompts, each written to avoid those failures. Every technical prompt asks for your version, your layout, and an explanation you can actually check.

What's inside

• 65 formula and function prompts - lookups, text, dates, conditional logic, dynamic arrays, and debugging
• 55 data cleaning prompts - numbers stored as text, broken dates, duplicates, merged cells, and messy exports
• 60 dashboard, chart and PivotTable prompts
• 55 automation prompts - Power Query, VBA and Office Scripts
• 60 financial modelling prompts - structure, three-statement builds, scenarios and model review
• 55 troubleshooting, speed and best-practice prompts
• 20 Power Modifiers that upgrade any prompt instantly

Written for people who actually use Excel

Analysts, accountants, finance teams, operations managers, and anyone who has ever spent an afternoon fighting a formula that should have taken two minutes.

Covers Excel 365, 2021, 2019 and 2016, with Google Sheets differences flagged throughout. Works with ChatGPT, Claude, Gemini and Copilot.

Not affiliated with or endorsed by Microsoft Corporation.