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

⌚ 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

📩 NEWSLETTER

🔽 CONNECT WITH ME

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

#stratvert #chatgpt #excel

[BrianHurn]

Kevin's first demo is a great example of how human error can lead to the incorrect answer even when the tools are behaving perfectly. He asks for the sum of the values in B2 through B10, but his data is actually in B2 through B11.

[Armen_]

Your teaching method is perfect. It's brief and at the same time concise plus you highlight some tips that not everyone knows but if someone is interested he/she can follow up on that subject and learn it later.

[epicstories]

Kevin has not only provided such crucial information at such juncture when chatgpt has just begun to roll out but also helped us integrate it with excel. You are very helpful Kevin ☺️

[nwinburn]

I love Excel, and even use it for fun - more often than I feel comfortable saying. I have created the most complicated scenarios that I can think of and asked ChatGPT to come up with formulas and/or functions that I thought were impossible, and the results have been amazing!

[drdheerajtumu]

Kevin dear, this video is gonna boost my productivity for sure. I've only recently developed my first likings for ChatGPT and now you give me more reasons to keep it always on my pc. Thanks for touching on the macros part also. I used to feel that it is onerous.

[amazingtechtutorials]

Another great video Clear, concise, useful, and entertaining. Thanks Kevin.

[aspuzling]

I'm a coder but every now and then I need to write a fairly complicated Excel or Google Sheets formula and it takes me a while to scour tutorials, read documentation and figure how to do it. ChatGPT is going to make writing up these formulae so much easier.

[aditya_suresh]

Great video, as always! Thanks for sharing these good ideas, Kevin!

[emilythechef]

Thanks for the lesson Kevin! Hopefully ChatGPT can teach me how to use arrays. Although, I heard some new formulas in 365 are reducing the need for arrays.

[justinabosco]

Kevin you are a star. I can't even express how much this helps me. Oh my god I spent hours googling formulas for the new invoice report i was asked for. 😅

[tizme]

This is impressive, my current task in Excel is complicated and executed manually, with limited formulae. the suggested Marcos mirror precisely the manual functions, will try them out on a test spread sheet. Thanks for the heads up.

[rsearchtim]

I like so many of your videos @kevin. This is yet another one. I never thought of Chat GPT for this.

[abiodunoshinowo]

This is incredible! I was taken abreast by the macros' section. Thank you @Kevin Stratvert. You are really amazing...

[homymehta]

Amazing job Kevin. Loved the simplicity of the video

[RavenZamir]

Clear, concise, useful, and entertaining. Thanks Kevin.

[ssaptaparni]

Kevin, loved this one! A similar video for MS Word would be great. 🤓🤓

[aloksharma]

Have been using chatGPT for a while. It really helps. Thanks for making such videos.

[davidcuff]

Kevin, thank you for all of you great videos.

[KenyaOnlineTv]

From Kenya, I love how you do your work. This is so amazing man! I have learnt alot from your video tutorials. Thanks so much

[SimpleSheets]

Excelformulabot utilizes GPT-3 for creating formulas. Super cool and well done.

Thanks for the video, Kevin!