Video course · 15 chapters · 49 min · certificate
Excel Copilot: 20 Essential AI Features for Effortless Data Analysis & Productivity
Master Copilot in Excel through 20 features: asking questions about data, generating content, reshaping data, extracting and splitting text, combining sheets, pivot tables, merging columns, enriching locations, lookups without VLOOKUP, charts, conditional formatting, date insights, cleaning data, feedback themes, multi-file analysis and Python in Excel.
What you'll learn
- Ask Copilot questions about data
- Transform, split and clean data
- Combine sheets and look up values without formulas
- Create pivots, charts and highlighting
- Turn feedback into themes
- Run advanced analysis with Python in Excel
Chapters
15 chapters · 49:04-
3:26
01Basics Members
Ask questions about your data
Overview and Q&A.
-
4:31
02Generate Members
Generate new content
Tables and scenarios.
-
3:54
03Transform Members
Transform and reshape data
Reshaping.
-
3:02
04Text Members
Extract and manipulate text
Pulling out parts.
-
2:09
05Split Members
Split text into columns
Tidy fields.
-
3:01
06Combine Members
Combine data across sheets
No VLOOKUPs.
-
3:45
07Pivots Members
Create pivot tables
Just describe.
-
3:04
08Merge Members
Combine two columns
Cleaner reports.
-
3:18
09Enrich Members
Enrich location data
Derived columns.
-
3:50
10Visuals Members
Lookups and charts
No formulas, quick charts.
-
3:08
11Highlight Members
Conditional formatting and dates
Rules and dates.
-
2:13
12Clean Members
Clean and standardise data
Consistent rows.
-
2:35
13Text analysis Members
Feedback into themes
Open-ended responses.
-
3:58
14Advanced Members
Segment feedback and multi-file
Products and files.
-
3:10
15Python Members
Python in Excel
Beyond native functions.
Jobs this course suits
Our AI checked this course against 500 jobs; these get the most out of it. Each job links to its learning path.