Learn how to work with Copilot in Excel for data analysis and automation.
Overview
Syllabus
Introduction
- Welcome to Copilot and AI-Powered Excel
- What to know before starting this course
- Working with Excel tables
- Getting your data into Copilot
- A tour of the Copilot editor
- Basic table reformatting with Copilot
- Using Copilot in Excel for non-Excel tasks
- Challenge: Table setup in Copilot
- Solution: Table setup in Copilot
- Creating Formulas and Functions Faster with Copilot
- Debugging Excel formulas with Excel Copilot
- Using Microsoft Copilot as an Excel formula tutor
- Data profiling
- Sorting and filtering data
- Working with multiple tables in Copilot
- Challenge: Enhancing a table with Copilot
- Solution: Enhancing a table 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
- Challenge: Copilot for data analysis
- Solution: Copilot for data analysis
- The Future of AI in Excel
Taught by
George Mount
Reviews
5.0 rating, based on 1 Class Central review
4.6 rating at LinkedIn Learning based on 1818 ratings
Showing Class Central Sort
-
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…