Microsoft Copilot & Azure AI
Mastering Microsoft Copilot for Microsoft Excel
A full day on Copilot in Excel.
1 dayAdvanced5 modules
About this course
A full day on Copilot in Excel. You will use Copilot to explore a dataset, clean it up for analysis, write and repair formulas, build charts and PivotTables, and surface insights in less time.
Curriculum
5 modules
- Write effective prompts
- Use the Copilot interface
- Ask natural-language questions about data
- Get high-level summaries and explanations
- Compare groups, categories, or time periods
- Identify structural issues that affect analysis
- Identify helper or descriptive columns
- Identify derived fields for grouping and time-based analysis
- Create formulas from plain-language descriptions
- Work with functions across tables and ranges
- Explain and fix existing formulas
- Summarize data across categories or time periods
- Create PivotTables and summary views
- Build charts to support analysis and insights
Who it's for
Excel users who analyse data, ideally after completing MS-4005 on prompt writing.
Before you start
- Before taking this course, it is highly recommended that students complete MS-4005 Craft effective prompts for Microsoft Copilot for Microsoft 365
Related courses
More in Microsoft Copilot & Azure AI →AdvancedAB-100T00
AB-100T00: Architecting agentic AI business solutions
Microsoft Copilot & Azure AI
View course →IntermediateAB-6007
AB-6007: Secure and Govern your AI agent workforce
Microsoft Copilot & Azure AI
View course →IntermediateAB-6008
AB-6008: Delegate work with Copilot Cowork
Microsoft Copilot & Azure AI
View course →IntermediateAB-620T00
AB-620T00: Design and build integrated AI agent solutions in Copilot Studio
Microsoft Copilot & Azure AI
View course →IntermediateAB-730T00
AB-730T00 Transform business workflows with generative AI
Microsoft Copilot & Azure AI
View course →IntermediateAB-731T00
AB-731T00 Drive AI transformation in your organization
Microsoft Copilot & Azure AI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.