After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
Gone are the days of hunting for formulas and cleaning data cell by cell with Microsoft Copilot in Excel. In this course, you'll use Copilot to generate tables, explain formulas, tidy text, connect data with lookups, build summaries and charts, surface data quality issues with conditional formatting, and run multi-step analysis—from correlation to theme summaries. Discover how you can spend less time wrestling with spreadsheets and more time uncovering insights with Microsoft Copilot today!
Feels like what you want to learn?
Start Course for FreeWhat you'll learn
- Create structured tables and get formula explanations using Microsoft Copilot in Excel, and know when to use Agent Mode versus ask-only mode.
- Craft effective prompts that reference tables and columns explicitly to extract, standardize, and transform data, and avoid vagueness and context leakage.
- Connect data across tables with lookups and build presentation-ready summaries and charts using Copilot so you can present insights without writing formulas.
- Apply conditional formatting with Copilot to highlight blanks, duplicates, and key values, and verify that rules target the right ranges.
- Run multi-step analysis—correlation, visualizations, and theme summaries—using Copilot and validate interpretive results against the original data.
Prerequisites
There are no prerequisites for this course
Curriculum
Course outline
1
Getting Started with Copilot in Excel
Turn messy spreadsheets into clean, analysis-ready data in minutes—no formula hunting required. Utilize Copilot in Excel to generate tables, explain formulas, and tidy text while you focus on what the data means.
- Unlocking AI-Enabled Analysis50 XP
- Generating a project tracker with Copilot100 XP
- Creating and explaining formulas with Copilot100 XP
- Automated Transformations and Formulas50 XP
- Classify Copilot prompting practices100 XP
- Extract region and department from ticket IDs100 XP
- Standardize inconsistent priority values100 XP
2
Copilot-Powered Analysis Workflows
Out with the old ways and in with the new! You'll discover how to spend less time writing and fixing formulas and more time uncovering insights and creating presentation-ready summaries. Power your analysis with natural language!
3
Data Quality, Insights, and Oversight
Spot data quality issues and surface insights at a glance. Use Copilot to apply conditional formatting that highlights blanks, duplicates, and the values that matter, then run multi-step analysis—correlation, charts, and theme summaries—while you validate results and stay in control.
Microsoft Copilot in Excel
Course
Complete
