Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Excel with Copilot: AI-Driven Data Analysis

Excel with Copilot: AI-Driven Data Analysis

44mIntermediate2024-03-07

Authors

George Mount

George Mount

Course details

In this course, analytics author, trainer, and Excel MVP George Mount highlights the role of Copilot in automating Excel tasks and the potential of AI-driven data manipulation and analysis. Learn how to prepare your data to be compatible with Copilot and how to set up and reformat tables using Copilot. Find out how to use Copilot to speed up creating formulas and functions, conduct basic data profiling and exploration, and sort and filter data. Go over conditional formatting, advanced data analysis and insights, and AI-powered data visualization. Build your understanding of the evolving AI landscape in Excel and learn to embrace continuous learning for AI technologies!

Skills covered

Microsoft CopilotSpreadsheetsMicrosoft ExcelAI Productivity ToolsArtificial Intelligence for BusinessData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off

Concepts

0. Introduction

  • 01 - Welcome to Copilot and AI-Powered Excel
  • 02 - What to know before starting this course

1. First Steps with Copilot

  • 03 - Getting your data into Copilot
  • 04 - A tour of the Copilot editor
  • 05 - Basic table reformatting with Copilot
  • 06 - Challenge - Table setup in Copilot
  • 07 - Solution - Table setup in Copilot

2. Data Management with Copilot

  • 08 - Creating formulas and functions faster with Copilot
  • 09 - Data profiling
  • 10 - Sorting and filtering data
  • 11 - Challenge - Enhancing a table with Copilot
  • 12 - Solution - Enhancing a table with Copilot

3. Analyzing and Visualizing Data with Copilot

  • 13 - Conditional formatting
  • 14 - Advanced data analysis and insights
  • 15 - AI-powered data visualization with Copilot
  • 16 - Challenge - Copilot for data analysis
  • 17 - Solution - Copilot for data analysis

Conclusion

  • 18 - The future of AI in Excel

Related courses

Related learn paths

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal