Every Excel formula you've ever learned, you learned the same way: you needed a number, you didn't know the function, so you typed a rough guess into Google, opened four tabs with different argument orders, and copied whichever matched your data closest. SUMIFS alone has cost people entire afternoons over comma placement.
Copilot in Excel skips that detour. You describe the number you want in a sentence, and a working formula lands in the cell. The first time it happens on your own data, not a demo screen, something shifts: the tool stops being an abstract "AI feature" and becomes a shortcut for the part of Excel you already understood conceptually but had never memorised the syntax for.
The mental model
Copilot isn't reading your spreadsheet the way you do. It's matching your sentence to a formula shape it has seen paired with similar sentences before, then filling in the blanks with whatever it can see: your column headers, the range you've selected, the sheet name. Think of it as briefing a new hire who has memorised every function in Excel but has never opened your workbook. Give them a specific, well-scoped ask and they'll produce something close to what you'd have written yourself. Give them a vague one over messy data and they'll hand back something confident-sounding and wrong.
That's the whole model. It isn't reasoning about your business, it's translating a description into syntax, the same operation you'd do by hand once you knew every function name cold. The value isn't that it understands your numbers better than you do, it's that it already has the vocabulary you're still building.
The syntax
Two different things share the same name here, and mixing them up is where people get burned.
The first is the Copilot pane. Select a range or a table, open Copilot, and describe the outcome:
Total revenue by region for Q2, only Closed Won deals.Copilot writes a normal formula into the cell, usually built from SUMIFS, XLOOKUP, or a nested IF. Once it lands, it behaves like any other formula in the sheet. Click into the formula bar, read it, edit it, drag-fill it, audit it in six months the same way you would anything else.
The second is the literal =COPILOT() worksheet function, typed straight into a cell:
=COPILOT("Summarise the trend in this range and flag any outlier month", C2:C13)This one stays alive. Every recalculation re-runs the prompt against the current data and returns a fresh AI answer, which suits summaries and commentary and poorly suits anything you need to reproduce exactly.
Revenue share by region, only Closed Won deals
Say you've got a deals table: Region, Deal Stage, Revenue, Quarter, one row per deal. You want a column showing each region's revenue as a percentage of the total, counting only deals marked Closed Won. You open the Copilot pane and type roughly that sentence.
Copilot proposes:
=SUMIFS($D:$D,$A:$A,A2,$C:$C,"Closed Won")/SUMIFS($D:$D,$C:$C,"Closed Won")Read what happened. It matched "percentage of total" to a SUMIFS-over-SUMIFS pattern, one summing by region and criteria, one summing by criteria alone as the denominator. It matched "only Closed Won" to a third argument in both. It read the header row to guess which column is which. None of this is new logic, it's exactly the formula a competent analyst would write by hand. It's just arriving before you've had to remember SUMIFS' argument order yourself.
That's the click this post is named for. Not that a number appeared. Calculators produce numbers. That a formula you could have written, but hadn't yet learned to write, showed up as a normal, inspectable formula instead of a black box.
What it doesn't do
Microsoft's own documentation is blunter about this than most AI features bother to be: it recommends against using the COPILOT() function for anything requiring accuracy or reproducibility, and points you back to native formulas for that instead. Worth taking at face value, because the failure patterns are specific and repeatable, not occasional flukes.
Merged cells confuse it. Blank rows inside a table confuse it. Inconsistent column headers, stray spaces, a column mixing text and numbers, all of these push it toward the wrong range or the wrong assumption. On more layered asks, formulas built from dynamic arrays sometimes reference the wrong range entirely, or return a placeholder variable instead of the range you meant. Occasionally it invents a function name that doesn't exist in Excel and hands you a formula that simply errors. If your locale uses a semicolon instead of a comma as the argument separator, that's one more thing it can get backwards.
None of this is an argument against using it. It's an argument for treating a Copilot-written formula the way you'd treat one copied from a forum post: read the formula bar before you trust the number, check the range references actually point at your table rather than a guess, and if the number is about to feed a decision, re-derive it by hand once. That's not scepticism for its own sake, it's the same check you'd run on a formula a junior analyst handed you with no explanation.
Frequently Asked Questions
Does Copilot in Excel mean I don't need to learn formulas anymore?
No, but it changes when you learn them. You can get a working answer today and pick up the syntax by reading what Copilot wrote, instead of blocking the task on learning function names first. Understanding the formula in front of you is still what lets you catch it when it's wrong.
Do I need a Microsoft 365 Copilot licence to use this?
Yes. Formula generation and the COPILOT() function sit behind the Microsoft 365 Copilot add-on, not the base Excel or Microsoft 365 subscription. Check your organisation's licensing before planning a workflow around it.
What's the actual difference between asking in the Copilot pane and typing =COPILOT() into a cell?
The pane writes a standard, native formula, SUMIFS, XLOOKUP, whatever fits, that behaves like any other cell formula once it lands. =COPILOT() stays a live AI call that re-runs on every recalculation, better suited to summaries than to numbers you need to reproduce exactly.
Does this work on Mac?
Yes. Copilot's editing and formula features have rolled out to Mac and the web as well as Windows desktop, though new capabilities have historically landed on Windows first. If a specific feature isn't showing up, check whether it's reached your platform before assuming it's broken.
Can Copilot fix a formula that's already wrong instead of writing a new one?
Yes. Select the cell, describe the change you want in plain English, and Copilot updates the existing formula rather than replacing it with something unrelated. Useful for adjusting a criteria or range without retyping the whole thing.
What should I actually check before trusting a number Copilot produced?
Click into the formula bar and read the formula. Confirm the range references point at your real table, not a guess. Watch for merged cells, blank rows, or inconsistent headers in the source range, all three are known to throw it off.
If you want the harder-edged version of this argument, that most Copilot scepticism is really people who haven't opened the thing, that's the Stop reading Copilot hot takes and just open the thing Hot Take. And if a full mental model is more than you need today and you want one three-minute win instead, One Copilot prompt that summarises a 20-tab workbook is the Click Bait version of this same thread.