Agent Mode is a new AI-powered assistant inside Microsoft Excel (part of Microsoft 365 Copilot). Agent Mode can fix broken formulas and generate new dynamic formulas that work across your data; generate data analysis and identify anomalies; create pivot tables, charts, dashboards, and other typical Excel artifacts – all by asking with normal language. Microsoft has also integrated web search into Agent Mode for access to updated information from the web – and is available in Excel on Windows and macOS.
