برای استفاده کامل از سایت، جاوااسکریپت را فعال کنید.

JavaScript is required for the full experience. You can still browse these pages:

Excel with Copilot: AI-Driven Data Analysis

44mIntermediate2024-03-07

Authors

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