Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

AI-Powered Excel: Mastering Built-In Automation Features

via LinkedIn Learning

Overview

Harness the power of Excel’s built-in AI features with the help of Microsoft MVP George Mount.

Syllabus

Introduction
  • Welcome to AI-powered Excel
  • What to know before starting this course
1. AI-Driven Data Manipulation
  • 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
2. Advanced Data Entry and Forecasting
  • 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
3. AI-Powered Charts and PivotTables
  • AI-powered data visualization with Recommended Charts
  • AI-powered data summaries with Recommended PivotTable
  • Challenge: Exploring NYC population trends
  • Solution: Exploring NYC population trends
4. Analyze Data: Deep Dive
  • 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
Conclusion
  • Where to learn more about AI for Excel

Taught by

George Mount

Reviews

4.7 rating at LinkedIn Learning based on 551 ratings

Start your review of AI-Powered Excel: Mastering Built-In Automation Features

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.