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

LinkedIn Learning

Excel with Copilot: AI-Driven Data Analysis

via LinkedIn Learning

Write review

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Leverage Copilot in Excel to automate data preparation, formula creation, analysis, and visualization tasks while building foundational skills for AI-driven productivity.

Syllabus

Introduction
  • Welcome to Copilot and AI-powered Excel
  • Working with Excel tables
1. First Steps with Copilot
  • Getting your data into Copilot
  • A tour of the Copilot editor
  • Basic table reformatting with Copilot
  • Using Copilot CHAT in Excel for non-Excel tasks
  • Challenge: Table setup in Copilot
  • Solution: Table setup in Copilot
2. Data Management with Copilot
  • Creating formulas and functions faster with Copilot
  • Debugging Excel formulas with Excel Copilot
  • Using Microsoft Copilot as an Excel formula tutor
  • Using the COPILOT() function
  • Data profiling
  • Sorting and filtering data
  • Working with multiple tables in Copilot
  • Challenge: Enhancing a table with Copilot
  • Solution: Enhancing a table with Copilot
3. Analyzing and Visualizing Data with Copilot
  • Conditional formatting
  • Advanced data analysis and insights
  • AI-powered data visualization with Copilot
  • Introducing advanced analysis with Python for Copilot
  • Time series analysis with advanced analysis in Copilot
  • Text analysis with advanced analysis in Copilot
  • Researcher and analyst agents in Copilot
  • Challenge: Copilot for data analysis
  • Solution: Copilot for data analysis
Conclusion
  • The future of AI in Excel

Taught by

George Mount

Reviews

5.0 rating, based on 1 Class Central review

4.5 rating at LinkedIn Learning based on 4029 ratings

Start your review of Excel with Copilot: AI-Driven Data Analysis

  • Profile image for Mishi Eman
    Mishi Eman
    2
    Despite its impressive features, Copilot does have some limitations, particularly when dealing with incomplete or erroneous data, which can affect the accuracy of its recommendations. Additionally, for highly specialized tasks, users may still need…

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.