AI in Excel, 2026: What You Can Actually Use Today

✍️ Prasad TR, ExcelSchooling.com  📅 July 2026  ⏱ 6 min read

A participant in a recent batch opened Excel, typed a prompt he’d seen in a YouTube video, and got nothing — no Copilot button, no response. He wasn’t doing anything wrong. He was on a plan and platform where that specific feature simply doesn’t exist yet.

That mismatch is the actual story of “AI in Excel” right now. It isn’t one feature — it’s about nine of them, scattered across different Microsoft 365 plans and platforms, and a few haven’t even reached Excel for the web. This guide sorts out what you can use today, what’s genuinely coming, and which platform gap is probably the reason your screen doesn’t match someone else’s demo.

Access Map — At a Glance

What You Can Use Today (and What I Demo in Class)

These work on Excel for the web, no AI add-on required — and they’re what I actually put in front of students first, because everyone in the room has access on day one.

Flash Fill — start typing a pattern (splitting a full name into first/last, reformatting a date) and Excel finishes the rest of the column on its own. Ctrl+E, or Data → Flash Fill.

Power Query — not flashy, but it’s still the backbone of clean data. Connects, cleans and reshapes data from multiple sources before it ever hits your sheet. Data tab → Get Data.

Forecast Sheet — select a time-based dataset and Excel projects it forward with a confidence interval built in, no formula required. Data tab → Forecast Sheet.

Copilot in Excel (chat pane) — on a plan with Copilot, this is the one that changes how a class reacts. I’ll type something like:

Copilot returns a working IF/COUNTIF-based formula in seconds. The useful part of the demo isn’t the speed — it’s the next five minutes, where we check whether it referenced the right range and handled blank cells correctly. That’s the actual skill.

What’s Rolling Out (and I’m Learning Before I Teach It)

These are real, confirmed Microsoft features. I’m testing each one properly myself before it goes into the course — so what gets demoed is something I’ve actually run, not a slide from Microsoft’s announcement page.

Python in Excel — runs pandas, matplotlib and other Python libraries from inside a single cell, calculated in Microsoft’s cloud with no local Python install. Already live on Excel for web for Business/Enterprise accounts; Personal/Family plans need the Insider beta channel.

Agent Mode / Edit with Copilot — instead of just suggesting a formula, Copilot can make the changes directly in your workbook. Give it a goal —

— and it plans the steps, builds the tables and charts, and shows you the plan before it touches anything. Needs a Microsoft 365 Copilot or Copilot Pro license.

The =COPILOT() function — calls AI directly inside a formula, e.g. classifying feedback or summarizing a range, recalculating like any other formula when your data changes.

Which Microsoft 365 Plan Unlocks What

Pricing and rollout stages change often, so I confirm the current state on the plan you’re using during training, rather than assuming it matches whatever Microsoft announced that month.

Quick Reference Checklist

• Flash Fill, Power Query, Forecast Sheet — work on the free/base plan, no Copilot needed
• Copilot chat pane — needs Microsoft 365 Copilot or Copilot Pro
• Python in Excel — check File → Options; Business/Enterprise may already have it on web
• Agent Mode / Edit with Copilot — needs Microsoft 365 Copilot or Copilot Pro license
• =COPILOT() function — Windows/Mac only, not yet on web, regardless of license