English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 44m | 123 MB
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!
Table of Contents
Introduction
1 Welcome to Copilot and AI-Powered Excel
2 What to know before starting this course
First Steps with Copilot
3 Getting your data into Copilot
4 A tour of the Copilot editor
5 Basic table reformatting with Copilot
6 Challenge Table setup in Copilot
7 Solution Table setup in Copilot
Data Management with Copilot
8 Creating formulas and functions faster with Copilot
9 Data profiling
10 Sorting and filtering data
11 Challenge Enhancing a table with Copilot
12 Solution Enhancing a table with Copilot
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
Resolve the captcha to access the links!