Microsoft Mechanics Podcast Microsoft Excel Power User Updates | Agent Mode, Copilot Function & Formula AI
6 snips
Oct 30, 2025 Discover innovative ways to transform raw data into stunning visual dashboards and key performance indicators with Agent Mode. Automate complex analyses and create pivot tables effortlessly. The Copilot function can categorize feedback and score sentiment within your worksheets. Experience the magic of Formula AI, generating precise formulas from plain language prompts. Jeremy Chapman shares tips to enhance productivity and drive faster, data-driven decisions in Excel.
AI Snips
Chapters
Transcript
Episode notes
Copilot Embeds AI Directly In Excel
- Microsoft 365 Copilot brings AI deeply into Excel to help analyze, create visuals, and apply formulas without leaving the app.
- These capabilities aim to keep data safe within managed Microsoft environments rather than uploading files to external AI sites.
Agent Mode Builds A Live Dashboard
- Jeremy Chapman demos Agent Mode creating an insights dashboard from raw sales and feedback data in a few minutes.
- The agent generated pivot tables, charts, KPIs, and recommendations and explained its reasoning steps while building the workbook.
Agent Mode Explains Findings And Rationale
- Agent Mode not only creates visual outputs but also lists insights like KPIs, segment profitability, and discount impacts.
- It provides recommendations and a transparent explanation of how it produced the results for verification.