In this step-by-step tutorial, learn how to leverage OpenAI's ChatGPT tool to massively increase your productivity and skills in Microsoft Excel. Create simple formulas with ease, perform complex two dimensional lookups, extract text, and create powerful macros with ease. ChatGPT is a game changer and an essential tool to add to your kit!

File I used to follow along: [ Ссылка ]
(remember to convert to .xlsm if using macros)

⌚ Timestamps
Intro 0:00
Get ChatGPT 0:17
1A. Simple Average 0:57
1B. Simple IF 2:04
2. SUMIFS 3:00
3. Text Extraction 4:56
4. Index Match 7:26
5. Macros 9:56
Outtro 13:12

Thanks for watching - have you used ChatGPT for anything cool in Excel?

свернуть