In this step-by-step tutorial, learn how you can exponentially improve your Excel skills using OpenAI’s ChatGPT artificial …
source
In this step-by-step tutorial, learn how you can exponentially improve your Excel skills using OpenAI’s ChatGPT artificial …
source
🥷 Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/
📚 Article that walks through ChatGPT in Excel: https://kevinstratvert.com/2023/01/18/10x-your-excel-skills-with-chatgpt/
📩 Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
This is very insightful, I really love the Macros part. Thank you, thank you!
Nice information Kevin
Thank you
I asked ChatGPT how was this video and it said, " Kevin, you are simply the best." Just kidding, it is me who is saying so. Brilliant, as always short and to the point. Well done.
I have used ChatGPT to write VBA code and it doesn't always work. I attempted to get code to fetch a table of the current London MetallExchange prices several times and none of the variations ChatGPT produced worked.
teaching method is perfect
yea but sooner or later, microsoft will release microsofy copilot which infused to microsoft excel, and it will be more powerfull
Kevin, there is a photo of another person with your name on this channel. Who is it?
Chat GPT is a Democrate propaganda tool, DO NOT USE IT! I told you 1st!!
Great video!!! What a fantastic tool
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.
Thank you for assuring me that the technology used is way beyond my comprehension. I'd like an easy voice to Windows alternative.
Hmm, i do not trust robots
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.
THANKS
That was a great education for free, thanks
Hi sir
I want to learn Database making
Would you help me!
I don't understand this
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…
My mind just blew up. This just changed my workflow.
Dude you are awesome
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 🙂
Auto sum ?
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
Good share
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.
With my less computer skill, felt so hard to get it…
Timestamps courtesy of Deciphr AI 👨💻
0:01:04 ChatGPT to Enhance Excel Functionality
0:02:32 ChatGPT to Simplify Excel Formulas
0:06:17 ChatGPT to Get Unique Counts and Summing Values
0:07:55 How to Write an Excel Macro with ChatGPT
0:10:22 How to Use Excel Macros to Send Customized Emails
Our favorite quote ✍
Microsoft, maybe you should look at incorporating some ChatGPT functionality into your insert function.
I use this video for sleep, it makes me sleep faster
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?
Great video!
Great video!
WHATTTTT!!!????????? Is ChatGPT single? (Asking for a friend…)
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
Great vid! Just that Google Spreadsheets extension already builds in OAI prompts, but back and forth pages still works 🙂
Thank you sir 🙏
Absolutely amazing video dear Kevin.
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.
Have been using chatGPT for a while. It really helps. Thanks for making such videos.
Microsoft did just that. You asked for it. Thanks for asking for it.
EPIC!
Thank you
Thanks, great video.
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.
Comments are closed.