AIToday
Large Language ModelsITmedia AI+Published: Sep 15, 2026, 13:00 JST

Microsoft MVP shows Microsoft 365 Copilot doing Excel work by voice

Microsoft MVP shows Microsoft 365 Copilot doing Excel work by voice

3 Key Points

  1. What happened

    Microsoft MVP Kazuaki Asada set Microsoft 365 Copilot to "Allow edits" mode and asked it in plain language to fill rows delayed 10 days or more in red. Copilot did it correctly.

  2. Why it matters

    Work that used to require configuring conditional formatting rules or filtering cells by hand can now be done by describing the task. Copilot also matched a product master list by product name and flagged unmatched rows as errors.

  3. What to watch

    The hardest test — building a dashboard with pivot tables and charts — is shown only in ITmedia's TechLIVE video, so whether Copilot handles that reliably is not settled here.

WHO IT HITSBusiness teams that live in Excel — sales operations, reporting, and data-reconciliation staff — would need far less formula knowledge, since plain instructions replace manual conditional formatting and VLOOKUP/XLOOKUP entry.

Ask the AI about this article →

Summaries like this, in your inbox every morning.

Context & Analysis

Asada, who holds Microsoft's "Microsoft MVP" designation, built his demo around a made-up data set from an electric-vehicle maker's sales department. The sheet held salesperson names, product names, quantities sold and delivery-delay days — the kind of working file that many teams keep. Against that backdrop, the two tasks he chose are the ones that most often stall non-expert users: highlighting late orders, and matching one table to another.

In the first task, Copilot filled the delayed rows red after being told to mark rows delayed 10 days or more. That is work that previously meant setting conditional-formatting rules or filtering and recoloring cells by hand. In the second, it updated the unit-price column using product names as the key against a master list, and showed errors for names that could not be matched, as Asada had requested. These are the steps VLOOKUP and XLOOKUP normally require, with their lookup value, range, column number and match type.

The last demo — building a report with pivot tables and charts — is the one the article does not resolve, pointing instead to ITmedia's video channel. So the practical question for Excel-heavy teams is whether that multi-step work holds up the way the first two did; the small demo shown here suggests the simpler editing and matching tasks are already within reach.

FAQ
What do I have to turn on for Copilot to change my Excel file?
You need to switch Copilot into "Allow edits" mode. Only then can it follow plain-language instructions to edit your Excel data and documents.
Can Copilot replace VLOOKUP and XLOOKUP work?
Yes. Told to update unit prices by matching product names against a master list, Copilot filled the column correctly, and rows that could not be matched showed errors as instructed.
Did Copilot handle the complex dashboard task?
That part is not shown in the article. The article directs readers to ITmedia's video channel "TechLIVE" to see whether Copilot can handle the multi-step pivot table and chart work.

Get the latest Large Language Models news every morning

For example, today's edition would include:

  • Meta rolls out Meta One subscription globally, adds TaiwanDIGITIMES Asia · 25m ago
  • SAP CEO Christian Klein: keyboard ends at SAP in 2–3 yearsFortune AI · 25m ago
  • Workiva puts human sign-off at center of agent roadmapSiliconANGLE AI · 3h ago

AI-summarized, only the topics you pick — one digest a day via Email, Slack, or Discord.

Free · 30 seconds with Google · unsubscribe anytimeWhat is AIToday? →

Ask AI

Ask AI anything about this article. Q&As are published on this page for other readers too.

Related Articles

Next articleDario Amodei urges AI slowdown; AMD, Micron, Intel fall