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…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
lol if you have to use chat gpt to sum a range of cells stop using excel immediately and hire someone else to do the work….also yes you can use chat gpt to create very simple macros however like you saw it most likely will have errors and if you don't write macros and have no experience with them then you will get an error and back to square one not using a macro… the world went gaga over chat gpt but me personally i think its got much more work to do, learn, and prove.
can you filter it in the excel itself like a plug in?
Hello Mr Kevin I hope a problem with my microsft the ads isn't activated in my account I use my college email
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!
The solution ChatGPT offers to the second challenge is not the simplest, most obvious one.
Instead of: =SUM(A2-B2)
=A2-B2 is a much simpler, more intuitive solution.
Now, we are talking here about the most basic functions in Excel.
If for such simple operations ChatGPT does not always offer the simplest solution, can I trust it in more complex challenges? I doubt it.
Thanks, great video.
Thank you
EPIC!
Microsoft did just that. You asked for it. Thanks for asking for it.
Have been using chatGPT for a while. It really helps. Thanks for making such videos.
Looks like you still need some advanced knowledge of Excel. Like how you discovered the error in the macro. It still has a ways to go.
Absolutely amazing video dear Kevin.
Great vid! Just that Google Spreadsheets extension already builds in OAI prompts, but back and forth pages still works 🙂
Be careful though. I signed up for the free plan but ChatGPT billed me $20 for the Pro Plan even though I hadn't given them my banking information or authorization to use it. so how did they get my banking information. I made a video on my experience if you want my thoughts
WHATTTTT!!!????????? Is ChatGPT single? (Asking for a friend…)
Great video!
Great video!
I tried everything, and it worked. I asked it to create a macro using Gmail, and it responded with, "Note that to use this macro, you will need to have Outlook installed and configured with a Gmail account. You may also need to adjust the line.SendUsingAccount = OutlookApp.Session.Accounts.Item(1) to set the correct Gmail account as the default account." How do you configure it?
I use this video for sleep, it makes me sleep faster
With my less computer skill, felt so hard to get it…
20 yrs ago I used my excel skills to describe geometry that could be seen as structure or turn it around as waves. You have no idea what I'll do after I open an account and Wright python. You're to young to realize what the hippies will do with GPT4 And GPT next! YOUR GEN IS A PRODUCT OF OUR IMAGINATION, WE ARE THE CREATORS. Lots more reality to create.
Good share
Hi can chat gpt write in excel what I say to it? We have to make mesuerments at work and it always hast to be 2 people. It would be cool if chatgpt would write what I say and where I say . We strong understaffed
Auto sum ?
Have been using ChatGPT to help with tricky functions that I'm not familiar with and it's been amazing… easier than googling to find the answer 🙂
Dude you are awesome
My mind just blew up. This just changed my workflow.
It's still the human component that counts most, in your first example you forgot about Bangladesh (B11) with a revenue of $108.862.210, as you asked ChatGPT to make the formula for B2 to B10…
I don't understand this
Hi sir
I want to learn Database making
Would you help me!
That was a great education for free, thanks
THANKS
I was an excel pro mega formulas and VBA (retired now) I used user group and just asked experts for help. ChatGPT is totally amazing.
Hmm, i do not trust robots
Thank you for assuring me that the technology used is way beyond my comprehension. I'd like an easy voice to Windows alternative.
It doesn't work I asked it to create a formula to find a string within a string. The string to find starts with a U and is followed by 7 numbers. It kept giving me wrong formulas. When I told it why it's formulas were wrong it was unable to learn.
Great video!!! What a fantastic tool
Chat GPT is a Democrate propaganda tool, DO NOT USE IT! I told you 1st!!
Kevin, there is a photo of another person with your name on this channel. Who is it?