Video course · 6 chapters · 12 min · certificate
Imrpove Your Excel Skills with ChatGPT
10x your Excel skills with ChatGPT: simple sums and profit formulas, lookup functions, nested LEFT and FIND, unique counts, and writing VBA macros from scratch.
What you'll learn
- Get formulas for sums and profit
- Write lookup formulas
- Build nested text formulas
- Count unique values
- Generate VBA macros
Chapters
6 chapters · 11:39-
1:04
01Intro Members
Introduction and getting ChatGPT
10x Excel.
-
2:26
02Basics Members
Simple sum and profit
Describe the need.
-
1:46
03Lookups Members
Lookup functions
Sugar cookies.
-
1:10
04Text Members
Nested LEFT and FIND
Extract first names.
-
1:17
05Unique Members
Unique count
A classic challenge.
-
3:56
06Macros Members
Write macros and wrap up
VBA from scratch.
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.