Copilot In Excel: Building Dynamic Dashboards
 

Create professional, interactive Excel dashboards by combining foundational Excel skills with Microsoft Copilot for AI‑powered optimization.
Course details
Discover how to turn raw data into dynamic Excel dashboards with Microsoft Copilot. In this hands-on course, instructor Ann Emery-an expert with decades of Excel experience and an early adopter of Copilot for Excel-shows you how to combine essential Excel skills with AI-powered automation to build a professional, interactive dashboard using survey data from a fictional hotel. Designed for Excel and Copilot users who manage or analyze data, the course covers core dashboard components-datasets, PivotTables, PivotCharts, and slicers-while using Copilot to brainstorm KPIs, generate formulas, create visualizations, and apply clean formatting. Ann also highlights when Copilot support helps and when manual techniques offer more control.
Skills covered
Microsoft Copilot, Microsoft Excel