Hey!

I didn’t think I’d ever say this about an Excel formula, but…

This is wild.

Excel just dropped a new AI-powered function called =COPILOT() and it’s like having ChatGPT inside your spreadsheet.

What’s it do?

Let’s say you’ve got:

• 100 messy survey responses
• Or customer reviews that need categorizing
• Or a block of data screaming “help me make sense of this”

Now you can just type:

=COPILOT(“Summarize this feedback”, A2:A100)

And Excel gets to work, analyzing, organizing, rewriting, summarizing, generating. All in your sheet. All in real-time.

Here’s what else it can do:

• Classify support tickets by topic or sentiment
• Brainstorm marketing ideas inside a cell
• Generate SEO keywords based on product names
• Rewrite your team’s update in a better tone
• Build tables, lists, or project outlines on the fly
• Explain formulas in plain English (finally)

And it plays well with the Excel you already know:

• Use it inside formulas like IF, LAMBDA, SWITCH, etc.
• Reference ranges and cells as context
• Everything updates automatically when your data changes — no refresh needed

How to use it:

=COPILOT(“your instruction”, [context1], “more instruction”, [context2]…)

So you can say:

=COPILOT(“List top 5 cities by revenue”, B2:B100)

Or

=COPILOT(“Rewrite this email in a friendly tone”, A2)

A few things to keep in mind:

• Max 100 calls per 10 mins (for now)
• Doesn’t fetch live web data (yet)
• Doesn’t train on your data (privacy ✅)
• Works on Excel for Windows, Mac, and soon Web
• Requires Microsoft 365 Copilot license

Give it a spin.

Best,
Abi