The way we work with spreadsheets is undergoing a quiet but massive revolution. For decades, Microsoft Excel has been the ultimate playground for data modeling, budgeting, and business intelligence—but its full power was often reserved for formula wizards and VBA experts. Today, AI-driven assistants are democratizing these capabilities.
With the latest updates, Microsoft has evolved Copilot from a basic sidebar chatbot into an autonomous editor and collaborative partner. If you are looking to save hours of manual data wrangling and formula debugging, understanding how to steer these new capabilities is the key.
To help you stay ahead, we've broken down the major changes, the underlying science of how we collaborate with AI, and the best way to master these features through the Celoris Master Copilot in Excel Course.
1. The Three-Mode Framework: Chat, Edit, and Plan
Copilot in Excel now operates under a unified three-mode framework designed to balance safe exploration, direct execution, and strategic planning:
- Chat Mode: Safe and risk-free. In this mode, Copilot analyzes your workbook data and provides insights, explanations, and answers without making any direct changes to your file. It is perfect for asking, "Which product line had the highest growth last quarter?" or having Copilot explain a complex, nested formula in plain English.
- Edit Mode (Default): Direct and active. Here, Copilot edits your workbook directly based on your instructions. It writes working formulas, applies conditional formatting to highlight critical numbers, sorts and filters data, and builds PivotTables and charts right inside the grid.
- Plan Mode: The strategic buffer. Designed for more complex, multi-step operations, Plan Mode acts as a "think-before-you-act" checkpoint. Instead of executing actions immediately, Copilot outlines a step-by-step plan first. You can review what Copilot intends to do, modify individual steps, and approve the workflow before a single cell is edited.
2. The Science of "Plan Mode": Why Upfront Planning Works
Does stopping to plan with an AI actually make you more productive, or does it just add unnecessary overhead?
A July 2026 academic paper titled "Plans Work in Mysterious Ways: Evaluating a Plan Mode for Spreadsheet Agents" published on arXiv evaluated this exact question. Researchers conducted a controlled user study (N=24) comparing a plan-based approach with direct immediate editing (Act Mode).
The findings were striking:
- Massive Reduction in Refinement Loops: When using Plan Mode, users spent significantly fewer turns refining spreadsheets post-hoc (averaging 1.4 refinement turns compared to 2.2 turns in direct Act Mode). Because potential errors and structural misunderstandings were caught in the planning phase, the final output was correct much faster.
- More Efficient AI Reasoning: Upfront planning significantly lowered the computational cost. The average number of LLM tokens used during reasoning, messaging, and editing was reduced from 17.0k tokens in Act Mode to just 11.0k in Plan Mode.
- Surfacing Requirements Early: Under direct editing, 35% of a user's requirements only emerged after seeing an incorrect spreadsheet edit. In Plan Mode, 37% of requirements were successfully surfaced before execution by responding to clarifying questions asked by the AI.
- Enhanced Creativity and Agency: Users overwhelmingly preferred Plan Mode across dimensions of creativity support and human-machine collaboration. It gave spreadsheet authors a feeling of true partnership, keeping their attention focused on the task rather than fighting the AI's direct actions.
3. Going Fully Autonomous: Agent Mode
When tasks grow from single actions (like creating a formula) into complex, multi-step workflows (like building an entire interactive dashboard), Agent Mode takes over.
Generally available across Excel for Web, Windows, and Mac as of early 2026, Agent Mode is integrated directly into the "Editing with Copilot" sidebar. It transforms Copilot into an active collaborator that takes your high-level goal, autonomously drafts a plan, executes actions step-by-step, validates its own outputs, and corrects errors along the way.
Key Features of Agent Mode:
- Model Switching: Excel now features an integrated model switcher, giving users visibility and choice. While the system defaults to selecting the best model automatically, users can explicitly choose between OpenAI's GPT 5.2 (built for rapid, structured problem-solving) and Anthropic's Claude Opus 4.5 (ideal for tasks requiring open-ended reasoning and detailed explanations).
- Web-Grounded Search: Agent Mode features integrated web search with source citations. This means you can prompt the agent to "Pull in the latest exchange rates for our vendor currencies" or "Add a column showing the average monthly temperature for these vacation spots," and Copilot will fetch and cite real-world data directly.
- UI-Based Control: The interface includes a dedicated Plan pane that displays a persistent, visible plan. Users have the unique capability to partially execute the plan (e.g., executing up to Step 3 to review progress) or edit the steps directly in the UI before execution begins.
4. Advanced Analytics: The Evolving Role of Python in Excel
Advanced data analysts should note that Microsoft has restructured its Python features in Excel. The older "App Skills" feature, which ran text and Python analyses inside the Copilot grid, was retired in early 2026 to make way for a more specialized, dual-path architecture:
- The
PY()Function: This native Excel formula allows you to write and execute Python code directly inside an Excel cell. The code executes securely in Microsoft's cloud sandbox—meaning no local installation is needed—though it typically requires a separate Python in Excel license. - The Analyst Agent: For deeper, exploratory work across multiple files, commercial users can utilize this dedicated agent. You can attach messy datasets, ask complex analytical questions, and receive a beautifully written report with charts—all without modifying your original, underlying Excel file.
5. Licensing and Setup: How to Access Copilot in 2026
If you are confused about how to get access to these features, you aren't alone. Microsoft completed a major licensing overhaul in 2026:
- The Retirement of Copilot Pro: The standalone $20/month Copilot Pro subscription was officially phased out, with support ending on August 1, 2026.
- Current Subscription Paths:
- Individual Users: Access advanced editing capabilities via a Microsoft 365 Personal or Family subscription (utilizing a monthly AI credits plan) or a Microsoft 365 Premium subscription ($19.99/month) which bundles AI features across Excel, Word, PowerPoint, Outlook, and OneNote.
- Business Users: Require a commercial Microsoft 365 Copilot license or a Copilot Chat-eligible enterprise subscription.
- Technical Requirements: To ensure Copilot functions correctly, your files must be stored in OneDrive or SharePoint with AutoSave enabled.
(Note: Agent Mode in Excel is currently rolling out globally but is not yet available to customers in the EU or UK).
6. How to Master Excel Copilot Today
Having access to these powerful AI tools is only half the battle. To truly unlock their productivity-boosting benefits, you must learn the "language of AI"—how to write precise prompts, establish guardrails, and critically verify outputs.
If you want to transition from a beginner to an advanced AI power user, the Celoris Master Copilot in Microsoft Excel Course is the ultimate step-by-step guide.
Course At a Glance:
- Format: 6-week, self-paced online course (totaling 12–15 hours).
- Pricing: Currently on a limited-time 50% discount at just ₹1,200 (reduced from ₹2,400).
- Key Learnings:
- Module 1 & 2: Preparing data ranges into proper Excel Tables with clean headers so Copilot performs reliably.
- Module 3: Translating natural-language prompts into working formulas (like XLOOKUP and SUMIF) and debugging broken syntax.
- Module 4: Generating smart data visualizations, PivotTables, and summary reports.
- Module 5 & 6: Mastering the difference between Plan Mode and Agent Mode, including designing prompts and setting checkpoints for autonomous workflows.
- Module 7 & 8: Prompt-writing anatomy, governance, and a comprehensive Capstone Project using messy, real-world data.
- Certificate: A verified Celoris Certificate of Completion is provided.
Whether you are a marketing manager reviewing product reviews, a finance professional managing budgets, or an Excel user tired of googling syntax, learning to steer Copilot will easily cut your weekly reporting prep time in half.
Don't let the future of work pass you by. Invest in your skills and register before the upcoming batch on October 1st closes on September 22nd!