
Welcome to this Cloud Wars Agent and Copilot Update. In these discussions, I’ll be analyzing opportunities, impact, and outcomes possible with AI; today’s focus is on Agent Mode in Excel.
Highlights
00:10 — Agent Mode acts as a digital teammate, understanding user goals and generating dynamic dashboards with realistic sample data. It persistently refines and improves spreadsheets, allowing users to add features like Gantt charts and custom chart colors. It’s a significant shift from static Excel use to collaborative data management.
00:40 — Agent Mode is autonomous; it can act and create within spreadsheets, turning ideas into working tools instantly. It behaves like a master of Excel, understanding user goals and generating dynamic dashboards with realistic sample data.
01:45 — I personally struggle with maintaining a clean, visual project portfolio using Excel. With Agent Mode, users can simply ask Excel to create a project portfolio tracker with specific formatting and data relationships. The AI in Agent Mode instantly structures the data, applies formatting, and builds professional-grade dashboards without user intervention.
02:53 — The persistence and context of Agent Mode remembers and refines the underlying logic of the spreadsheet. The AI adapts to user needs, making spreadsheets dynamic applications rather than static data containers.
04:06 — Agent Mode is part of Microsoft’s Frontier program and requires a Microsoft 365 Copilot licensed subscription. Agent Mode represents a foundational shift from using Excel as a static tool to collaborating with it as a digital teammate.

AI Agent & Copilot Summit is an AI-first event to define opportunities, impact, and outcomes with Microsoft Copilot and agents. Building on its 2025 success, the 2026 event takes place March 17-19 in San Diego. Get more details.





