- Agent Mode brings step-by-step, AI-driven workflows to Excel and Word.
- Excel gets native formula reasoning, visuals, and iterative validation loops.
- Word introduces conversational drafting with clarifying questions and styled output.
- Office Agent in Copilot chat creates decks and docs; availability starts via Frontier.
Microsoft is rolling out a new way to work in Office: Agent Mode in Excel and Word, designed to turn natural prompts into finished spreadsheets and documents with guided, multi-step reasoning. Instead of one-off answers, you collaborate with an AI that can plan, execute, and verify tasks as it goes.
Built on Copilot’s latest reasoning capabilities, this approach aims to make advanced skills approachable for everyone. The idea is simple: you describe the outcome, and the agent tackles the heavy lifting—while you steer, review, and iterate in the flow.
What’s new: Agent Mode inside Excel and Word
Agent Mode runs directly in the apps many people use daily. In Excel and Word, Copilot now behaves more like a specialist who can break down complex requests into smaller actions, show progress in a sidebar, and keep refining until the result is ready to use.
In practice, that means you can ask for an end‑to‑end analysis, a styled report, or a formatted template—and see the steps the agent takes to get there. The goal is to deliver high-quality, audit-ready outputs without requiring expert-level know‑how.
Agent Mode in Excel: native spreadsheet reasoning
Excel’s Agent Mode brings AI that can effectively “speak Excel.” It selects appropriate formulas, builds new sheets, and creates charts as needed—then validates the work through iterative checks and corrections. For non-experts, it’s like handing a task to a seasoned modeler and supervising the outcome.
Give Copilot a prompt such as “Run a full analysis on this sales dataset and make it visual.” The agent chooses techniques, generates visuals, and returns a summary of what it found, along with the steps it took, so you can fine‑tune the result together.
Microsoft cites internal benchmarking to underline progress: on SpreadsheetBench, Agent Mode in Excel scored 57.2% accuracy versus 71.3% for human experts. While there’s still daylight to close, the emphasis is on repeatable validation and transparency over each action taken.
Excel scenarios where Agent Mode shines include month‑end close packs, price/volume analysis, forecasting models, and tools like loan calculators or household budget trackers with conditional formatting. The agent aims to combine speed with traceability, so teams can review and trust what’s produced.
Agent Mode in Word: conversational, guided writing
In Word, Agent Mode turns drafting into a dialogue. You describe what you need—“summarize recent customer feedback and highlight trends,” for example—and Copilot drafts, asks clarifying questions, suggests edits, and applies native styles on the fly.
It doesn’t stop at summaries or rewrites. The agent can update monthly reports with new figures, compare against last month’s doc, bold key findings, and insert next steps. The experience is meant to feel iterative and collaborative, not transactional.
Styling is handled in stride: title case for section headers, brand‑aligned formatting, or italicizing external partner mentions. The result is a document that’s both polished and easy to maintain across recurring cycles.
Office Agent in Copilot chat: chat-first creation
Work often starts in chat, and that’s where Office Agent in Copilot comes in. Powered by Anthropic models, it can create PowerPoint presentations and Word documents from a single prompt, guiding you through clarification, research, and content generation, apoyándose en agentic AI.
A typical flow looks like this: it clarifies goals (length, audience, theme), conducts relevant web research, and produces a ready‑to‑share deck or doc. From there, you can iterate on visuals and structure in chat or continue editing in the Office apps with Copilot.
Examples include executive briefings, internal campaigns, or market overviews—useful when you need a solid first draft quickly, then refine collaboratively.
Prompts to try (paraphrased)
For Excel, you can ask the agent to “Build a monthly close report for a bike shop, with product-line breakdowns and year-over-year trends,” or “Create a loan calculator with payment schedule and remaining balance.” It can also set up a personal budget tracker with data bars and a donut chart for spending distribution.
For Word, try “Update this September report using figures from the latest inbox data pull and compare to August,” or “Revise the executive summary for clarity, bold the key takeaways, and list next steps from the project update.” You can also request style cleanup aligned to your brand guidelines.
Availability and how to get started
Agent Mode in Copilot for Excel is available now through the Frontier program for Microsoft 365 Copilot licensed customers and Microsoft 365 Personal or Family subscribers. It currently works on the web, with desktop support coming soon. To try it, install the Excel Labs add‑in and choose Agent Mode.
Agent Mode in Copilot for Word is also beginning its rollout via Frontier for the same customer groups. It’s available on the web first, with desktop to follow. Office Agent is available via Copilot on the web in English for Microsoft 365 Personal or Family subscribers in the United States.
Why it matters: quality, validation, and control
Agent Mode is built for transparency: it shows the actions it takes, re‑checks intermediate results, and welcomes user oversight. The Excel benchmark figure (57.2%) reflects meaningful progress but also underscores the need for review on critical business tasks.
Microsoft’s framing is clear: this isn’t about hypey shortcuts; it’s about delivering reliable, auditable artifacts faster—documents, spreadsheets, and presentations that teams can adapt and trust. With a measured rollout on the web and a focus on enterprise‑grade controls, the company is positioning agentic workflows as a pragmatic next step for Office users.
Between in‑app Agent Mode and the chat‑first Office Agent, organizations get two complementary paths to produce work: hands‑on, stepwise creation inside Excel and Word, and rapid, prompt‑driven drafting in Copilot chat—both designed to keep you in control while the AI handles the heavy lifting.
