What is Cowork? Use Cases Services FAQ Book a Call
Use Case

AI Excel & Sheets Formulas with Claude Cowork

Stop Googling spreadsheet syntax. Describe what you need in plain English and Claude writes the formula in seconds — with an explanation if you want one.

25 min → 90 sec to build a complex formula
See training options ($199/$449/$2,500) → or book a free call
Time saved
25 min → 90 sec
Setup time
5 minutes
Difficulty
Beginner

The Problem

Every team has someone who's "good with spreadsheets." That person ends up being interrupted constantly — "can you help with a formula?" — or the rest of the team loses 20 minutes Googling syntax and copy-pasting StackOverflow answers that don't quite work.

The hidden cost is huge. A finance team can lose 5+ hours a week to formula-debugging. An ops team burns hours stitching together VLOOKUPs that should be INDEX/MATCH or XLOOKUP. Marketing teams build pivot tables three times because the first two had the wrong fields.

Claude Cowork removes the friction completely. You describe what you want in plain English — "I need to count rows where column B is 'Active' AND column D is greater than 100" — and Claude writes the formula. Want to know how it works? Ask for an explanation. Want a Google Sheets version? Just say so. The whole loop takes 30 seconds.

What Claude Does Here

How to Set It Up

1

Open Claude alongside your spreadsheet

This works best with Claude in a side window. No setup, no integration — just two windows.

2

Describe your data structure

Tell Claude what columns you have, what the data looks like, and which platform (Excel or Google Sheets). 30 seconds.

3

Ask for the formula in plain English

"Count rows where status is Active and amount is over 100." "Look up the manager name from sheet 2 based on employee ID." That's all the input Claude needs.

4

Paste and adapt

Claude returns the formula with placeholders for your specific cell ranges. Swap them in, hit enter, done.

5

Ask "why does this work?"

If you want to understand the formula (instead of just using it), ask Claude to walk through each part. Over a few weeks you'll find you barely need to ask — you'll know the patterns.

Example Prompt

Prompt
I have a Google Sheets with the following columns: - Column A: Customer Name - Column B: Industry - Column C: Deal Value (in dollars) - Column D: Status (one of: Open, Won, Lost) - Column E: Close Date (MM/DD/YYYY format) I need a formula that: 1. Counts the number of "Won" deals where Industry is "Staffing" AND Close Date is in 2026 2. Returns the total value of those deals as a separate formula Give me both formulas, then briefly explain how each one works.

What Claude Returns

Claude's Output
FORMULA 1: Count of Won Staffing deals in 2026 =COUNTIFS(B:B, "Staffing", D:D, "Won", E:E, ">="&DATE(2026,1,1), E:E, "<="&DATE(2026,12,31)) FORMULA 2: Total value of those deals =SUMIFS(C:C, B:B, "Staffing", D:D, "Won", E:E, ">="&DATE(2026,1,1), E:E, "<="&DATE(2026,12,31)) HOW THEY WORK: COUNTIFS counts rows that match ALL of the criteria you give it. We're saying: count rows where column B is "Staffing", AND column D is "Won", AND column E is on or after 01/01/2026, AND column E is on or before 12/31/2026. The ">="&DATE() syntax is how you compare dates in COUNTIFS — the & concatenates the operator with the date value. SUMIFS works the same way, but instead of counting matching rows, it sums up the values in column C for those rows. Same criteria, different aggregation.

Real US small business formula scenarios

Three worked examples from US sectors we work with — each with a plain-English prompt you can copy, and the formula Claude typically returns. All tested in both Excel and Google Sheets.

1. Accounting — sales tax reconciliation across state ledgers

The bane of quarter-end for any multi-state seller. You’ve got a sales ledger, a tax collected ledger, and state-by-state records that don’t quite tie back. Claude writes the reconciliation formula that flags mismatches by state and period.

Prompt
I have two sheets in Excel: - Sheet "Sales": columns A (invoice date MM/DD/YYYY), B (customer), C (state), D (net amount), E (sales tax collected), F (tax rate) - Sheet "StateTax": columns A (period), B (state), C (tax collected) Write a SUMIFS formula that goes in Sheet "StateTax" column D. It should sum the sales tax from Sheet "Sales" that matches the current row’s state AND falls within the current row’s period (Q1 = Jan-Mar, Q2 = Apr-Jun, etc.). Explain what to change if a period isn’t a standard calendar quarter (e.g. a fiscal year starting October).

Typical output: a working SUMIFS using date bounds with EOMONTH to handle quarter-end boundaries, plus the exact substitution to use for non-calendar fiscal years (e.g. October year-end).

2. Real estate — cap rate & cash-on-cash yield from a portfolio spreadsheet

US real estate investors calculate returns at gross vs net levels, and need to account for US-specific costs (property taxes, HOA fees, property management, mortgage interest). Claude handles the correct formula given whatever cost columns you actually have.

Prompt
I have a Google Sheet tracking rental properties in Austin, TX and Phoenix, AZ: - Column A: property address - Column B: purchase price - Column C: monthly rent - Column D: annual property management fees - Column E: annual maintenance budget - Column F: annual insurance + property taxes - Column G: mortgage interest per year Write two formulas that go in columns H and I: - Column H: cap rate (%) — annual NOI (rent × 12 minus D+E+F) divided by purchase price - Column I: cash-on-cash yield (%) — annual rent minus all costs (D+E+F+G), divided by purchase price Format both as percentages to 2 decimal places. Then write a conditional formatting rule that highlights any property with cap rate below 5% in red.

3. Staffing agency — commission calculation with tiered rates

US staffing & recruiting commission structures often have tiered rates (e.g. 15% up to $100k billing, 20% from $100k-250k, 25% above $250k). Writing this by hand with nested IF statements is painful and error-prone. Claude writes it in one go and can convert to IFS if you’re on a modern Excel or Sheets version.

Prompt
I need an Excel formula for tiered commission calculation. Consultant total billings for the year are in cell B2. Commission structure: - 15% on billings up to $100,000 - 20% on billings between $100,000 and $250,000 - 25% on billings above $250,000 The commission should be cumulative — so someone billing $300,000 gets 15% on the first $100k, 20% on the next $150k, then 25% on the remaining $50k. Write the formula. Then write a simpler version using IFS() for Excel 2019+ users, and explain when to use which.

The complex nested version handles legacy Excel; the IFS version is cleaner if your team is on Microsoft 365. Both give the identical answer — Claude will show you both and note the difference.

★ Training for US Teams

Train your team to build formulas like this in under 10 minutes

Three training tiers for US businesses: self-paced ($199), live cohort ($449), or private team workshop ($2,500). All taught by UK-based Claude specialists who work with US teams daily.

Frequently Asked Questions

Does this work for both Excel and Google Sheets?
Yes. Claude knows the syntax for both, including the small differences (Google Sheets uses ARRAYFORMULA, QUERY, IMPORTRANGE; Excel uses XLOOKUP, FILTER, dynamic arrays). Tell Claude which platform you're using and it writes the right syntax. It also handles older Excel versions if you specify.
Can it explain why a formula works?
Absolutely — and this is one of its best features. Ask Claude to break down each part of a formula and it will walk you through what every function and argument does. You'll actually learn the formula, not just copy and paste.
What about complex pivot tables and Power Query?
Claude handles both. For pivot tables, you describe the data and the analysis you want, and Claude tells you exactly which fields to put in rows, columns, values, and filters. For Power Query, it can write M code to handle data transformations that would take 30 minutes manually.
Can Claude debug a formula that's broken?
Yes — paste the formula and the error you're getting (or the wrong output) and Claude will identify the issue. Common fixes include missing absolute references, wrong column counts in VLOOKUP, mismatched data types, and circular references. Saves hours of head-scratching.
Will this make me reliant on AI for spreadsheets?
Only if you let it. The smarter use is to have Claude explain each formula it writes — over time you'll learn the syntax patterns and only need Claude for the genuinely complex ones. Most teams find their core formula skills improve, not decline.
Does Claude know US-specific finance formats like $, MM/DD/YYYY dates, and US tax logic?
Yes. Reference “US format” explicitly in your prompt and Claude uses $, MM/DD/YYYY dates, and US fiscal year references (calendar year by default, or Oct-Sep federal fiscal year on request). For tax logic, Claude knows current US federal tax brackets and common state sales tax rates, but always verify the specific rate against IRS or state DOR guidance for anything client-facing.
Can it help with the specific quirks of US accounting software exports (QuickBooks, Xero, NetSuite)?
Yes — particularly for cleaning up messy CSV exports. QuickBooks’ multi-class exports, Xero’s date columns, and NetSuite’s saved-search CSVs all have known quirks that Claude can write formulas or Power Query steps to fix. Describe the export format and what you need — Claude handles the transformation.

Related Use Cases

Three ways for US teams to get started

Whether you want to train yourself, train a cohort alongside peers, or bring us in for a private team workshop — we've got an option that fits.

Self-paced ($199) Live cohort ($449) Book a Free Call