Excel's Biggest Upgrade Ever - How to Use Copilot

This 16-minute tutorial demonstrates how to leverage Microsoft Excel's new AI-powered Copilot assistant to transform your spreadsheet workflow. Learn how to enable and access Copilot, then discover practical applications including automating lookup functions, cleaning data, filling in missing information, extracting data, generating custom formulas, applying conditional formatting, sorting and filtering data, creating visualizations, analyzing sentiment in feedback, generating word clouds with Python, and building complete AI-powered dashboards. Follow along with the provided sample workbook as host Kevin Stratvert guides you through each capability, from basic data manipulation to advanced Python integration in Excel. Perfect for anyone looking to dramatically increase their Excel productivity through AI assistance.

Syllabus

00:00 - Introduction to Excel Copilot
00:28 - How to Get Copilot
01:08 - Where to Find Copilot
01:58 - Automate Lookup Functions
04:56 - Clean Data
07:15 - Fill in Missing Data
07:41 - Extract Data
08:05 - Generate & Use Custom Formulas
08:27 - Apply Conditional Formatting
08:55 - Sort Data
09:29 - Filter Data
10:00 - Summarize Data
10:43 - Visualize Data with Charts
11:10 - Analyze Sentiment for Feedback Visualization
11:38 - Generate a Word Cloud with Python
13:39 - Build AI-Powered Dashboards with Python
14:48 - How to Enable Python in Excel
15:02 - Explore Copilot’s Prompt Gallery
15:55 - Wrap Up