Harness the power of Excel’s built-in AI features with the help of Microsoft MVP George Mount.
Overview
Syllabus
Introduction
- Welcome to AI-powered Excel
- What to know before starting this course
- Automating data entry with Flash Fill
- Creating a Column by Example
- Creating a Formula by Example
- Joining tables with fuzzy matching
- Challenge: Flash Fill vs. Column by Example
- Solution: Flash Fill vs. Column by Example
- Importing data from a picture
- Introducing predictive analytics with Forecast Sheet
- Enhancing data insights with linked data types
- Challenge: Predicting the population of Europe
- Solution: Predicting the population of Europe
- AI-powered data visualization with Recommended Charts
- AI-powered data summaries with Recommended PivotTable
- Challenge: Exploring NYC population trends
- Solution: Exploring NYC population trends
- Introducing Analyze Data for AI-powered insights
- Preparing data properly for Analyze Data
- Challenge: Explore census trends with Analyze Data
- Solution: Explore census trends with Analyze Data
- Where to learn more about AI for Excel
Taught by
George Mount