Claude AI for Excel: Two Formula Jobs Worth Handing Over - PC Webinars blog post

Claude AI for Excel: Two Formula Jobs Worth Handing Over

There is a workbook in almost every class I teach that nobody wants to touch. It came from somebody who left the company two years ago, one column is full of formulas nobody can read, and the standing rule is: don’t change it, just keep it running. That is exactly the spot where Claude AI for Excel earns its keep — not building your spreadsheet for you, but explaining and stress-testing the parts you are nervous about.

The other half of the problem is newer and more annoying. You know what the answer is supposed to be. You just can’t remember whether it’s SUMIFS, XLOOKUP with a wildcard, or a helper column, and you have already lost twenty minutes to a column of #N/A.

Here are two jobs I hand over in class. Each one takes about five minutes, and neither asks you to trust the answer blindly. That last part matters more than people expect.

Use Claude AI for Excel to Explain a Formula You Inherited

Copy the formula out of the formula bar and paste it in with three things attached: what the columns actually hold, what you believe the formula is for, and the specific question you have. Vague input gets you a vague textbook answer about INDEX and MATCH. Specific input gets you something you can act on.

  • Here is a formula from a workbook I inherited: =IFERROR(INDEX($D$2:$D$5000,MATCH(1,($A$2:$A$5000=$G2)*($B$2:$B$5000=$H2),0)),"")
  • Column A is customer ID, column B is order month stored as text like 2026-03, column D is invoice total.
  • Explain in plain English what it returns, tell me what it does when two rows match, and list what would silently break it.

What comes back is a walk-through in sentences: it is a two-condition lookup, the multiplication is doing the AND, and it returns the first matching row only — so if a customer has two invoices in the same month, the second one is invisible. You also get told that the IFERROR wrapper is hiding every error, which means a misspelled customer ID and a genuinely blank result look identical on the sheet. That is the finding that costs people money, and it is the one nobody spots reading the formula on screen.

The gotcha: Claude cannot see your data unless you hand it some. Paste five real rows underneath the formula, with names scrubbed if you need to. Without rows it will describe the logic perfectly and still miss the actual bug — that column B is text while the lookup value in column H is a real date, so the match never fires.

Ask for the Formula and the Test Rows in the Same Breath

Most people ask “give me a formula that does X”, paste the answer into the sheet, and hope. One extra sentence turns that into something you can verify in a minute:

Write an Excel formula that [what you need]. Then give me four test rows to check it with — include one blank, one duplicate, and one number stored as text — and tell me what the formula should return for each row.

Now you have a test, not just an answer. Paste the four rows into empty space below your data, drag the formula next to them, and compare the results with what you were told to expect. All four agree, you’re fine. Row three disagrees, you have found the bug while it is still in a scratch area instead of in next week’s report. Then delete the scratch rows.

The gotcha: say which version of Excel you are on. Claude reaches for the modern functions by default — XLOOKUP, LET, TEXTSPLIT, dynamic arrays — and on Excel 2019 those land in your sheet as #NAME?. Adding “I’m on Excel 2019, no XLOOKUP and no dynamic arrays” or “this is a real Excel Table named tblOrders” to the end of the prompt is the difference between a formula that runs and ten minutes of debugging someone else’s assumptions.

Plenty more on the calendar

I’m running Claude AI for Excel live on Wednesday, November 18. We work both of these jobs on real workbooks — reading formulas you inherited, getting new formulas written and tested, cleaning up ugly exports, and the prompt wording that separates a useful answer from a confident wrong one — with time for your own questions at the end.

The full current schedule is on the front page of PCWebinars.com, and new dates go up there as they are confirmed. Register for this one, or have a look through the others and pick the session that matches whatever you are stuck on this month.

About your trainer

I’m Tom Fragale. I’ve been a computer trainer and consultant for more than 30 years, and I’ve taught well over 30,000 people how to get more out of the software they already own — Excel, Access, Power BI, Word, Outlook, and now the AI tools that sit on top of all of it: Claude, ChatGPT, and Microsoft Copilot. My background is applied, not theoretical. Alongside the teaching I build real databases and reporting systems for clients in Excel, Access, and Power BI, so the examples I use in class are the problems I ran into last week, not textbook exercises. I also publish free tutorials on YouTube and longer courses online.

Upcoming live sessions, recordings, and the rest of the catalog are all at PCWebinars.com.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *