Excel with Copilot: AI-Driven Data Analysis

Learn how to work with Copilot in Excel for data analysis and automation.

Introduction

• Welcome to Copilot and AI-Powered Excel
• What to know before starting this course
• Working with Excel tables

First steps with Copilot

• 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

Data Management with 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

Analyzing and Visualizing Data with Copilot

• Conditional formatting
• Advanced Data Analysis and Insights
• AI-Powered Data Visualization with Copilot
• Challenge: Copilot for data analysis
• Solution: Copilot for data analysis

Conclusion

• The Future of AI in Excel