Excel with Copilot: AI-Driven Data Analysis

Introduction

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

1. 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

2. 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

3. Analyzing and Visualizing Data 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

Conclusion

• The Future of AI in Excel