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:
– Excel workbook to follow along:
– Article that walks through ChatGPT in Excel:
β 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:
– How to create simple macros in Excel:
– Full tutorial on Excel Macros and VBA:
π© NEWSLETTER
– Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week:
π½ CONNECT WITH ME
– Official web site:
– LinkedIn:
– Discord:
– Twitter:
– Facebook:
– TikTok:
– Instagram:
π MY COURSES
– Go from Excel novice to data analysis ninja in just 2 hours:
π REQUEST VIDEOS
π SUBSCRIBE ON YOUTUBE
π SUPPORT THE CHANNEL
– Hit the THANKS button in any video!
– Amazon affiliate link: (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