Excel’s Mic Drop Moment (With a Slight Cough): It Can Now Write Formulae!

By someone who’s spent more time debugging spreadsheets than sleeping

In a move that’s equal parts revolutionary and quietly terrifying for anyone who’s built a career around knowing what =INDEX(MATCH()) does, Microsoft Excel has just dropped the mic. As of 2025, it can now write formulae for you. Not suggest. Not autocomplete. Actually write them, based on plain English prompts. It’s like asking your spreadsheet, “What’s the average revenue per region?” and it replying, “Hold my cell references.”

But before you start planning your early retirement from formula-writing, let’s address the caveats. Because of course there are caveats. This is Excel, not Hogwarts.

What It Can Do (And Why Your Pivot Table Just Looked Nervous)

Natural Language Formulae: Type =COPILOT("Total sales by region", A2:D100) and Excel will generate a working formula. It’s like having a polite intern who doesn’t ask for coffee breaks.
Sentiment Analysis: Feed it customer feedback and it’ll summarise the mood. Excel now understands that “Your product is a disgrace” is not a compliment.
Categorisation: It can sort feedback into themes like “Taste”, “Noise”, and “General Disappointment”. Ideal for product managers with thick skin.
Emoji Sentiment Columns: Yes, it can assign smiley faces to positive feedback. Because nothing says “professional dashboard” like a row of grinning yellow blobs.
Live Updates: The formulae update as your data changes. So when your Q3 figures nosedive, Excel will be the first to know. Followed shortly by your finance director.

What It Can’t Do (Yet — But Give It Time)

Complex Nested Logic: If your formula resembles a Victorian plumbing diagram of nested IFs and LAMBDAs, Copilot may quietly excuse itself and suggest a cup of tea.
Advanced Array Handling: It’s improving, but still not quite ready to tango with LET, SCAN, or anything involving curly brackets and existential dread.
Financial Modelling: It won’t replace your CFO. Though it may cause them to mutter darkly about job security.
Business Logic: Copilot doesn’t know your internal quirks. It won’t ask, “Are you sure you want to include the Milton Keynes office in this calculation?” It’ll just do it. Boldly.

Caveats and Conditions (Because of Course There Are)

Availability: Only for Microsoft 365 Copilot users on Windows, Mac, and web. You’ll need Excel Build 19212.20000+ (Windows) or 25081334+ (Mac). Web rollout is ongoing, like a slow-moving train with occasional Wi-Fi.
Storage Requirements: Your workbook must be saved to OneDrive or SharePoint. Local files are treated like suspicious parcels at airport security.
Usage Limits: 100 calls every 10 minutes, 300 per hour. So no, you can’t ask it to categorise every tweet about Collingtree Park Golf Club. Yet.
Licensing: Requires an active Microsoft 365 Copilot licence. If you’re on the free tier, you’ll need to continue your long-standing relationship with =SUM().

Final Thoughts

This isn’t just a feature update. It’s a quiet revolution. Excel has gone from “you must learn me” to “I’ll do it for you, mate.” Somewhere, an Excel trainer is clutching their pivot table and whispering, “It wasn’t meant to be this way.”

So next time someone asks how to calculate compound interest across three fiscal years with conditional formatting and a dash of existential dread, just smile, type =COPILOT("Calculate compound interest"), and walk away like you’ve just dropped the mic.

Because in 2025, Excel finally speaks human. And it’s surprisingly well-mannered about it.