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 Analysis

Generating a project tracker with Copilot

Creating and explaining formulas with Copilot

Automated Transformations and Formulas

Classify Copilot prompting practices

Extract region and department from ticket IDs

Standardize inconsistent priority values

Getting Started with Copilot in Excel

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!

Lookups You Can Trust

Add campaign names to the donations table

Add manager names and interpret a missing value

Sleek Summaries and Charts in Minutes

Summarize quarterly revenue by region

Create a chart of revenue by product category

Make the category chart presentation-ready

Copilot-Powered Analysis Workflows

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.

Conditional Formatting: When the Data Talks Back

Surfacing data quality issues with colors

Adding a splash of color to status columns

Advanced Analysis: Multi-Step Analytical Workflows

Investigate correlation between survey variables

Visualize engagement by region

Summarize feedback themes and validate

Congratulations!

Data Quality, Insights, and Oversight

Course Files

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!

Stop fighting Excel and start talking to it! Use Copilot in Excel to clean data, build charts, and get answers faster.

Microsoft Copilot in Excel

AI Curriculum Manager, DataCamp

Connecting data from two places

How XLOOKUP works

Example: Copilot and XLOOKUP

Verification checklist

Let's practice!

https://s3.amazonaws.com/assets.datacamp.com/production/course_44715/subtitles/course_44715_71e117cd14db2e2e263aad4677cf4a17.vtt

Copilot-Powered Analysis Workflows - Lookups You Can Trust

Lookups You Can Trust

Create Your Free Account