Course Overview
This course contains the use of artificial intelligence.
If you want to learn how to analyze your data using nothing more than plain English, this course is the one you're looking for. Copilot in Excel puts an AI data analyst right inside the spreadsheet you already use, and this course shows you exactly how to put it to work. Recorded in high definition video, it teaches you practical skills you can apply in your work environment immediately. Just take a look at the recent comments and reviews!
COURSE CONTENT AND OUTCOMES
This course teaches you how to use Copilot in Excel to turn your data into new insight and intelligence, simply by asking questions of it.
The ability to ask questions of your data is a powerful competitive advantage, resulting in new income streams, better decision making and improved productivity. Copilot removes the barrier between you and your answers. Instead of building analysis by hand, you describe what you want to know and Copilot does the heavy lifting, generating the tables, charts and summaries for you in seconds.
During the course you will learn how to write effective Copilot prompts, how to interpret what Copilot gives you back, and how to check its results so you can trust the insight you share. You will understand why each form of analysis matters and see it produced live using Copilot.
Using Copilot in Excel, you will learn to produce:
Key Metrics
Comparison Analysis
Trend Analysis
Ranking Analysis
Interactive Dashboards
Contribution Analysis
Variance Analysis
Pareto Analysis
Frequency Analysis
Correlations
For each one you will learn the plain-English prompts that get Copilot to do the work, so you can reproduce the same analysis on your own data straight away.
TWO COURSES IN ONE
As well as the new Copilot in Excel material, this course includes the original PivotTables course as a second part. There you will see how to create the very same types of analysis using PivotTables, the traditional way. This gives you the best of both worlds. You learn the fast, prompt-driven Copilot approach, and you also understand what is happening underneath so you can work confidently whether or not Copilot is available to you.
This course is designed for all business professionals who want to take their ability to turn data into information to the next level. If you are an Excel user then you will want to learn the easy, prompt-driven techniques that are taught in this course.
WHAT YOU NEED TO FOLLOW ALONG
The Copilot part of the course requires a Microsoft 365 subscription with Copilot enabled on your account, and it is presented using Copilot in Excel for Microsoft 365.
The PivotTables part of the course uses techniques that work in Excel 2016 and every version since, including Excel 2019, Excel 2021, Excel 2024 and Excel in Microsoft 365.
HOW YOU WILL LEARN IT
This is not a course you watch. Every analysis is followed by a written activity brief and the training data to do it on, then a video where I work through the answer with you. There are 26 written lessons and activity briefs in the course, and 42 downloadable data files. The course also includes two short, optional conversations with Ada, an AI character who plays your team lead: one at the start about the data you work with and what you want to learn, and one at the end to review the course.
WHO IS TEACHING YOU
I have been training business people to work with data since 2008, and publishing on Udemy since 2013. Across 16 courses that training has reached more than 400,000 students and 139,000 reviews, at an average of 4.6. This is the course I keep closest to current - it was last updated in July 2026.
START TODAY
By the end of this course you will be able to open a spreadsheet you have never seen before, ask it the right questions in plain English, and have a dashboard your manager can act on - in minutes, not an afternoon. And you will know how to build the same thing by hand when you need to. Enrol now and start with your first analysis today.
Please note that this course does not require any complicated formulas, VBA or macros. In the Copilot part you get Copilot to create the majority of the different data analysis techniques for you simply by asking, and in the PivotTables part you use straightforward drag and drop techniques.
FAQ
FAQ area empty
Course curriculum
Chương 1 Introduction to Course 5 bài · 3 phút
Chương 2 Part 1 Copilot: Getting Started with Copilot in Excel 2 bài · 6 phút
- Introduction to Copilot in Excel Học thử 0:50
-
Overview of Copilot in Excel 5:09
Chương 3 Part 1 Copilot: Preparing Data for Analysis 3 bài · 5 phút
- Introduction to Data Preparation Học thử 1:29
-
Preparing Data for Analysis 3:36
-
Data Preparation and Setup
Chương 4 Part 1 Copilot: Key Metrics 5 bài · 21 phút
-
Introduction to Key Metrics 0:58
-
Key Metrics Part 1 7:21
-
Personalising Copilot Prompts for Your Own Data 3:15
-
Key Metrics Part 2 9:20
-
Key Metrics Activity: Building HR Headline Metrics with Copilot
Chương 5 Part 1 Copilot: Comparison Analysis 4 bài · 16 phút
-
Introduction to Comparison Analysis 1:25
-
Comparison Analysis Part 1 5:41
-
Comparison Analysis Part 2 9:12
-
Comparison Analysis Activity: Comparing Headcount & Pay Across Departments
Chương 6 Part 1 Copilot: Trend Analysis 4 bài · 10 phút
-
Introduction to Trend Analysis 1:01
-
Trend Analysis Part 1 4:21
-
Trend Analysis Part 2 4:23
-
Trend Analysis Activity: Tracking Hiring Trends Over Time
Chương 7 Part 1 Copilot: Ranking Analysis 4 bài · 9 phút
-
Introduction to Ranking Analysis 1:03
-
Ranking Analysis Part 1 3:33
-
Ranking Analysis Part 2 4:25
-
Ranking Analysis Activity: Ranking Employees by Pay
Chương 8 Part 1 Copilot: Interactive Dashboards 4 bài · 9 phút
-
Introduction to Dashboards 0:42
-
Dashboards Part 1 4:37
-
Dashboards Part 2 3:41
-
Dashboards Activity: Building an Interactive Workforce Dashboard
Chương 9 Part 1 Copilot: Variance Analysis 5 bài · 12 phút
-
Introduction to Variance Analysis 1:11
-
Download the Training Data Files
-
Variance Analysis Part 1 5:03
-
Variance Analysis Part 2 5:50
-
Variance Analysis Activity: Month-on-Month Hiring Variance (Waterfall Chart)
Chương 10 Part 1 Copilot: Contribution Analysis 4 bài · 14 phút
-
Introduction to Contribution Analysis 0:55
-
Contribution Analysis Part 1 7:49
-
Contribution Analysis Part 2 5:17
-
Contribution Analysis Activity: Payroll Contribution by Department
Chương 11 Part 1 Copilot: Frequency Analysis 4 bài · 11 phút
-
Introduction to Frequency Analysis 0:53
-
Frequency Analysis Part 1 5:22
-
Frequency Analysis Part 2 4:46
-
Frequency Analysis Activity: Age-Band Distribution Histogram
Chương 12 Part 1 Copilot: Correlation and Pareto Analysis 4 bài · 21 phút
-
Introduction to Correlation and Pareto Analysis 1:18
-
Correlation Analysis 9:45
-
Pareto Analysis 10:06
-
Correlation & Pareto Activity: Pay vs. Age and Payroll Concentration
Chương 13 Part 1 Copilot: Python Visualizations 4 bài · 14 phút
-
Introduction to Python Visualizations 1:06
-
Matplotlib Visualizations 6:39
-
Seaborn Visualizations 5:59
-
Python Visualizations Activity: Matplotlib & Seaborn Charts for Hiring & Salary
Chương 14 Part 1 Copilot: Conclusion 1 bài · 1 phút
-
Course Conclusion 0:48
Chương 15 Introduction to Pivot Table Course 1 bài · 1 phút
-
Part 2 Pivot Tables: Introduction 0:51
Chương 16 Part 2 Pivot Tables: Data Analysis Foundations 4 bài · 3 phút
-
Introduction to Business Data Analysis 2:06
-
Section overview: Data Analysis Foundations
-
About the Course 1:23
-
Download the Training Data Files
Chương 17 Part 2 Pivot Tables: Preparing Data for Analysis 4 bài · 17 phút
-
Introduction to Data Preparation 1:19
-
Section overview: Preparing Data for Analysis
-
Preparing Data for Analysis 7:03
-
Common Data Problems 8:18
Chương 18 Part 2 Pivot Tables: Key Metrics 6 bài · 27 phút
-
Introduction to Key Metrics 1:23
-
Section overview: Key Metrics
-
Creating Key Metric Calculations - Part 1 10:06
-
Creating Key Metric Calculations - Part 2 8:42
-
Your turn: key metrics - employee count, age and tenure
-
Walkthrough: the key metrics exercise 7:10
Chương 19 Part 2 Pivot Tables: Comparison Analysis 5 bài · 29 phút
-
Introduction to Comparison Analysis 1:13
-
Comparison Analysis - Part 1 8:41
-
Comparison Analysis - Part 2 8:22
-
Your turn: comparison analysis - sales by manufacturer, brand and channel
-
Walkthrough: the comparison analysis exercise 10:20
Chương 20 Part 2 Pivot Tables: Trend Analysis 5 bài · 23 phút
-
Introduction to Trend Analysis 1:16
-
Trend Analysis - Part 1 9:02
-
Trend Analysis - Part 2 7:03
-
Your turn: trend analysis - profit trends by quarter with a trendline
-
Walkthrough: the trend analysis exercise 5:18
Chương 21 Part 2 Pivot Tables: Ranking Analysis 5 bài · 21 phút
-
Introduction to Ranking Analysis 2:07
-
Ranking Analysis - Part 1 9:05
-
Ranking Analysis - Part 2 5:37
-
Your turn: ranking analysis - top 15 products by sales
-
Walkthrough: the ranking analysis exercise 4:35
Chương 22 Part 2 Pivot Tables: Interactive Dashboard Creation 3 bài · 15 phút
-
Introduction to Interactive Dashboards 1:26
-
Interactive Dashboards - Part 1 7:53
-
Interactive Dashboards - Part 2 5:49
Chương 23 Part 2 Pivot Tables: Variance Analysis 6 bài · 27 phút
-
Introduction to Variance Analysis 1:20
-
Download the Sales Budget Data file
-
Variance Analysis - Part 1 10:56
-
Variance Analysis - Part 2 7:54
-
Your turn: variance analysis - monthly profit variance with data bars
-
Walkthrough: the variance analysis exercise 7:14
Chương 24 Part 2 Pivot Tables: Contribution Analysis 5 bài · 22 phút
-
Introduction to Contribution Analysis 1:35
-
Contribution Analysis - Part 1 5:29
-
Contribution Analysis - Part 2 9:36
-
Your turn: contribution analysis - profit share by country and category
-
Walkthrough: the contribution analysis exercise 5:26
Chương 25 Part 2 Pivot Tables: Frequency Analysis 5 bài · 14 phút
-
Introduction to Frequency Analysis 1:36
-
Frequency Analysis - Part 1 5:33
-
Frequency Analysis - Part 2 2:51
-
Your turn: frequency analysis - salary bands by gender
-
Walkthrough: the frequency analysis exercise 3:31
Chương 26 Part 2 Pivot Tables: Correlation Analysis 2 bài · 9 phút
-
Introduction to Correlation Analysis 1:20
-
Correlation Analysis 7:41
Chương 27 Part 2 Pivot Tables: Pareto Analysis 2 bài · 7 phút
-
Introduction to Pareto Analysis 1:34
-
Pareto Analysis 5:07
Chương 28 Part 2 Pivot Tables: Conclusion 2 bài · 1 phút
-
(Optional) Review the course with Ada
-
Conclusion 0:40
Requirment
-
Excel in Microsoft 365 with a Copilot licence, for Part 1 of the course
-
Excel 2016 or later for Part 2, including Excel 2019, 2021, 2024 and Microsoft 365
-
Comfort entering, sorting and filtering data in Excel. No formulas, macros or VBA required
-
Copilot in Excel on Mac trails the Windows rollout, so some Part 1 techniques may not yet be available to you
Outcomes
-
Analyse business data with Copilot in Excel using plain-English prompts, with no formulas, macros or VBA
-
Produce 10 core analyses: key metrics, comparison, trend, ranking, contribution, variance, frequency, correlation, Pareto and dashboards
-
Write Copilot prompts that return the right answer first time, and check the results before you share them
-
Build every one of the 10 analyses with PivotTables too, so you can still work when Copilot is unavailable
-
Create interactive Sales, Finance and HR dashboards that update as the underlying data changes
-
Generate Python charts inside Excel with Matplotlib and Seaborn, again just by asking
-
Prepare and present data using the practices that stop an analysis failing before it starts
0 Student
1 Course
0 review