The AI For Series
Cover of Excel + AI for Finance Teams by Chandan Gupta

The AI For Series

Excel + AI for Finance Teams

Use Claude for Excel and Claude Code to clean, reconcile, model and report, and keep your spreadsheets auditable

By Chandan Gupta, CA, CIA · 156 pages · Ebook

Google Play works on phone, tablet and web; Kindle on any Kindle app or device.

  • Claude for Excel vs Claude Code
  • 3 tested walkthroughs
  • 111 ready prompts
  • No coding

Who it's for

Accountants, controllers, FP&A analysts and AP/AR teams. Claude for Excel and Claude Code on real finance work: cleaning ERP exports, bank and intercompany reconciliations, month-end close, budgets, forecasts and 13-week cash, auditing an inherited model, and management reporting packs. When to use the Excel add-in, when to use Claude Code, and how to keep every workbook auditable.

What's inside

Part 1: Foundations

What leaves your laptop, how to set up on Windows or Mac, the ground rules that keep every workbook checkable, and when to use Claude inside Excel instead.

  1. What Leaves Your Laptop
  2. Set Up on Windows or Mac
  3. Ground Rules for Workbooks
  4. Claude Inside Excel, or Claude Code?

Part 2: Finance work

Seven areas of finance work, each with tasks Claude Code handles well, three worked examples and prompts you can copy.

  1. Cleaning Messy Exports
  2. Reconciliations
  3. Month-End Close
  4. Budgets, Forecasts and Cash
  5. Auditing an Inherited Model
  6. Management Reporting Packs
  7. Macros, Power Query or Python

Part 3: Working well

Checking what it gives you, turning your team's way of working into a playbook, and knowing when to stay in Excel.

  1. Checking the Output
  2. Your Team Playbook
  3. Limits, and When to Stay in Excel

Part 4: Try it yourself

Three end-to-end walkthroughs on downloadable practice files with planted traps, each run and checked against an answer key.

  1. Walkthrough: A Month-End Bank Reconciliation
  2. Walkthrough: A Quarterly Budget Versus Actual Pack
  3. Walkthrough: Reviewing an Inherited Forecast Model

Read the opening free

The introduction and first chapter as a PDF, no sign-up.

Download the free sample (PDF)

Free guides from this book

Questions

Who is this book for?

Accountants, controllers, FP&A analysts and AP/AR teams who live in Excel and want AI help they can check.

Claude for Excel or Claude Code: which one?

Chapter 4 compares them. The add-in works inside an open workbook; Claude Code works on files and folders and suits repeatable jobs such as a monthly bank reconciliation.

Do I need to code or know Python?

No. You describe the job, the AI writes the script, and the book shows how to check the output with tie-outs and control totals.

What do I need to follow along?

Excel on Windows or Mac and a paid Claude plan. The book links to its practice workbooks and answer keys.

About the author

Chandan Gupta, CA, CIA is a Chartered Accountant and Certified Internal Auditor, and the author of The AI For Series: practical books that put AI to work on real finance and audit tasks, tested on practice data. Amazon author page · LinkedIn

More in the series