Copilot for Excel

Topics covered include: 

• Identifying the different versions of Copilot and how to access it in Excel 

• Discussing what Copilot can do in Excel 

• Navigating the Copilot pane 

• Using Copilot for basic formatting commands 

• Applying basic and advanced conditional formatting with Copilot 

• Using Copilot to create formulas and functions 

• Identifying formula errors 

• Using Copilot to insert different types of charts 

• Creating prompts to analyze and summarize numeric and text data 

• Using Copilot prompts to manage data, including removing and filtering columns 

• Analyzing Outlook emails and OneDrive documents in Excel 

• Using Python for deep data analysis 

• Identifying best practices when using Copilot in Excel