Excel Copilot Agent Mode Builds Full Dashboards Automatically

Microsoft is rolling out Agent Mode for Copilot in Excel, and it's a significant step up from what's currently available. In this video, I walk you through exactly where to find it on both Excel for the web and Excel desktop, explain the difference between Chat and App Skills (and why that dropdown is going away), and show you Agent Mode in action. You'll see Agent Mode apply conditional formatting without requiring you to click Apply, and then build a full dashboard from scratch, complete with PivotTables, charts, and calculated profit figures, from a dataset with over 2,000 rows and no pre-existing profit column. I also cover the model options inside Agent Mode: Auto, GPT 5.2, and Claude Opus 4.5 from Anthropic, so you can choose which AI handles your task. This is a paid Microsoft Copilot license feature, currently available in the Beta channel for desktop. I'll tell you what to expect if you're on Monthly or Semi-Annual Enterprise channels, and where it's likely to appear first. If your role involves building reports or dashboards in Excel, this feature is worth knowing about now. Agent mode can tackle very complex and time-consuming tasks all on its own. Check out my Copilot, Excel, Teams, and OneNote courses: https://courses.chrismenardtraining.com Blog Post https://chrismenardtraining.com/post/... LinkedIn Post https://www.linkedin.com/posts/chris-... And make sure you subscribe to my channel! - EQUIPMENT USED -------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 - SOFTWARE USED -------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard Chapters: 0:00 - Intro 0:31 - Find Copilot on Excel for the web 0:49 - Understand Chat vs App Skills 2:06 - Use Chat to analyze a workbook 3:06 - Switch to Excel desktop and understand update channels 4:35 - Open Copilot on desktop and enable Agent Mode 5:09 - Apply conditional formatting with Agent Mode 5:55 - Select an AI model in Agent Mode 6:30 - Build a full dashboard with Agent Mode 7:13 - Verify the dashboard results 9:12 - Recap and rollout timeline DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!