What Copilot in Excel Is Actually Good For (and Where It Struggles)
It's decent at explaining formulas and drafting first attempts. It is not the assistant for messy real data.
By Shehryar Hassan, Microsoft 365 & Azure Consultant
A few people on my team asked me the same question after trying Copilot in Excel for the first time: is this actually useful, or is it just something Microsoft added to the ribbon because every product needs an AI button now?
After a few months of using it on real spreadsheets, I've landed somewhere in the middle. It's genuinely handy for a narrow set of tasks and mostly a distraction for everything else.
Where it actually helps
The best use I've found is asking it to explain a formula someone else built. If you inherit a workbook full of nested IFs and INDEX/MATCH combinations, you can select the cell and ask "what does this do" and get a plain English answer. That alone has saved me time more than once.
It's also decent at spotting patterns. Point it at a table and ask it to highlight outliers, or find duplicate rows, and it usually does a reasonable job. Same with quick summary columns, things like "flag any row where the total is more than 20 percent above the average."
And it's useful for a first draft of a formula when you roughly know what you want but can't remember the exact syntax. "Sum column C where column A is Open and column B is this month" gets you close enough to finish by hand.
Where it struggles
Anything that depends on structure it can't see gets shaky fast. If your sheet has merged cells, hidden helper columns, or formatting that carries meaning, like a colored cell meaning something specific, Copilot tends to miss it or guess wrong.
It's also not great with large, messy real-world data. Ask it to clean up a sheet with inconsistent date formats and mixed text and numbers in the same column, and you'll spend more time checking its work than doing it yourself.
The other thing worth knowing is that it can't see across multiple open workbooks. If your answer depends on a lookup in a different file, you're back to VLOOKUP or Power Query, not Copilot.
My rule of thumb now is to use it for understanding and drafting, not for anything that touches data I haven't already checked myself. It's a decent assistant for a single, well-structured sheet. Beyond that, the normal Excel tools are still faster and more reliable.
Get new posts by email
One note when there is something worth reading. No spam, unsubscribe anytime.
Related articles
Why Your Excel Conditional Formatting Rules Stop Working
If your conditional formatting rules used to work and now don't, the cause is almost always overlapping rules left behind from copy and paste, not a broken feature.
Why Your Word Document Opens in Protected View (and When It's Safe to Turn Off)
Word's Protected View isn't a glitch, it's a safety check for files that come from outside your trusted circle. Here's why it happens and when it's actually fine to click through it.
Why Your Outlook Search Doesn't Find Old Emails (and How to Fix It)
A short guide to why Outlook search misses emails you know exist, and the handful of fixes that actually work.