Video course · 9 chapters · 16 min · certificate
Excel Copilot Course
Kevin Stratvert's Excel Copilot course using the Kevin Cookie Company data: getting and finding Copilot, automating XLOOKUPs, cleaning and filling data, extracting values and custom formulas, conditional formatting, sorting and filtering, summaries and charts, sentiment analysis, Python word clouds and dashboards, and the prompt gallery.
What you'll learn
- Enable Copilot in Excel with AutoSave and cloud storage
- Automate lookups and generate formulas
- Clean, fill and extract data without destroying originals
- Format, sort, filter and summarise with prompts
- Create charts and analyse sentiment
- Use Python in Excel for word clouds and dashboards
Chapters
9 chapters · 16:13-
1:58
01Setup Members
Getting and finding Copilot
Turn on AutoSave.
-
2:58
02Lookups Members
Automate lookup functions
No syntax needed.
-
2:19
03Cleaning Members
Clean data
80% of the job.
-
1:12
04Formulas Members
Fill, extract and custom formulas
Ask, don't write.
-
1:02
05Formatting Members
Conditional formatting and sorting
Highlight and order.
-
2:09
06Analysis Members
Filter, summarise, chart and sentiment
Insights fast.
-
2:01
07Python Members
Word cloud with Python
Advanced analysis.
-
1:09
08Dashboards Members
AI-powered dashboards with Python
Charts in one prompt.
-
1:25
09Gallery Members
Prompt gallery and wrap-up
Explore more.
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.