10X Your Excel Skills with ChatGPT 🚀

Description

In this step-by-step tutorial, learn how you can exponentially improve your Excel skills using OpenAI's ChatGPT artificial intelligence. Write nested functions with ease, calculate the number of unique text values in a list, write a basic invoicing macro, and more, all with just a few clicks and a few basic refinements.

📚 RESOURCES

- OpenAI ChatGPT: https://chat.openai.com/

- Excel workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whYJ-sjcKPqzy6IZVYQ?e=H2FYXS

- Article that walks through ChatGPT in Excel: https://kevinstratvert.com/2023/01/18/10x-your-excel-skills-with-chatgpt/

⌚ TIMESTAMPS

00:00 Introduction

00:50 Get ChatGPT

01:04 Simple sum example

02:44 Profit example

03:30 Lookup functions

05:16 Left and find nested function

06:26 Unique count nested function

07:43 Write macros

10:51 Wrap up

📺 RELATED VIDEOS

- 5 Mind-blowing Artificial Intelligence Tools: https://youtu.be/v6OB80Vt1Dk

- How to create simple macros in Excel: https://youtu.be/uyj_OljPlcU

- Full tutorial on Excel Macros and VBA: https://youtu.be/IJQHMFLXk_c

📩 NEWSLETTER

- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME

- Official web site: http://www.kevinstratvert.com

- LinkedIn: https://www.linkedin.com/in/kevinstratvert/

- Discord: https://discord.gg/kHuujY2pZf

- Twitter: https://twitter.com/kevstrat

- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818

- TikTok: https://www.tiktok.com/@kevinstratvert

- Instagram: https://www.instagram.com/kevinstratvert/

🎒 MY COURSES

- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS

https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE

https://www.youtube.com/user/kevlers?sub_confirmation=1

🙌 SUPPORT THE CHANNEL

- Hit the THANKS button in any video!

- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)

#stratvert #chatgpt #excel