Excel's New AI Function is Absolutely Insane (Copilot Function)

12 minutesBeginnerPractitionerLeila GharaniAI Productivity

Leila Gharani. Live demo of the new `=COPILOT()` function on the kinds of messy real data the article describes — shift handover notes turned into a structured action table, free-text reviews tagged for sentiment, and inconsistent job titles normalized against a master list. Also calls out the limits clearly: don't use it for anything that has to be exact, freeze results as values when you're done.

AI Expert note

Watch for the limits as much as the demo: her own caveats — nothing that has to be exact, freeze results as values — are the same boundaries the article draws.

What you should get from this

See how spreadsheet AI can structure messy text and classify data, then check formulas and labels carefully.

Watch or know first

Microsoft 365 Excel with Copilot, plus comfort with ordinary formulas.

Last reviewed: May 18, 2026

Watch next

Continue through the same learning path with the next curated companion videos.