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

Options

Good prompting practice

Error-prone

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

Reference the table and column names in your prompt so Copilot knows what data to use.

Start a new chat when you switch to a different task.

Tell Copilot which columns to act on (e.g., "the Email column").

Rely on Copilot to guess which table or column to use.

Use one long chat for many different tasks.

Leave context from previous tasks in the conversation.

Classify Copilot prompting practices

Interaktive praktische Übung