12 Viewsยท 28 March 2023
10X Your Excel Skills with ChatGPT ๐
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
- Article that walks through ChatGPT in Excel: https://kevinstratvert.com/202....3/01/18/10x-your-exc
โ 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://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin....-Stratvert-101912218
- 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/k....evlers?sub_confirmat
๐ 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
0 Comments