AI-Powered Excel: Mastering Built-In Automation Features

Offered By: LinkedIn Learning

Tags

Artificial Intelligence Courses Flash Fill Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

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

Related Courses

Introduction to Artificial Intelligence
Stanford University via Udacity Probabilistic Graphical Models 1: Representation
Stanford University via Coursera Artificial Intelligence for Robotics
Stanford University via Udacity Computer Vision: The Fundamentals
University of California, Berkeley via Coursera Learning from Data (Introductory Machine Learning course)
California Institute of Technology via Independent