AI, Data Science & Business Certificates from Google, IBM & Microsoft
The Investment Banker Certification
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Learn how to work with Copilot in Excel for data analysis and automation.
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 2361 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…