🥷 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/ 📚 Article that walks through ChatGPT in Excel: 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: kevinstratvert.com/newsletter/
There seems to be a lot of hype about ChatGPT this week and month - seems well orchestrated. It is a bigger invasion of privacy than google as they are asking you for email AND phone number verified before you can even try it. No thanks. I am fine with duckduckgo.
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.
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.
You both point out a potential integrity issue customer service. However, I always learned from Kevin’s videos and find them very useful to boost my own productivity and learn the limitless opportunities with automation and operational processes. But who am I right? Lol 😢
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!
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 ☺️
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.
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.
I am motivated by the simplicity in your tutorial. As an African (Nigerian) I can understand your English very well. I have a challenge in editing text and videos on CapCut. In one the length of text exceed the video. Also the space for the text in CapCut could not contain the text from ChapGPT. I should be glad to have your videos on these issues. Thanks. 👍
ChatGPT looks like a great productivity and knowledge tool. Seems to me, there is 1 catch: ChatGPT makes small mistakes, and it takes real in-depth knowledge from the user to spot and tackle those mistakes. That's especially visible towards the end of the video, where Kevin manually corrects the Excel Macro code.
yeah that is true, but you can also ask ChatGPT if you don't understand something or you can ask ChatGPT to retry if there is a mistake or ask ChatGPT questions to find the error. That is a lot faster then learning an entire computer language.
What a ride, after watching this video I hyperfocused for like 6 hours lol, I've never programmed for shit but I have okay logic, so I was able to create a super worksheet that can bulk insert images and resize them one per cell, automatically add the dates of the pictures, a menu to display all of the companies that I offer services to, and with a single click it creates the PDF, exactly how I needed for my reports, changes the title to the company name, opens outlook, creates an email to be send to them with custom header and body and the PDF already attached just waiting for me to press send. And a handy button to clean everything when I want to make another one (I fucking hated selecting images one by one in Excel to delete them lol I was dumb af). Now I'm excited to share this with my coworkers and make everybody's jobs easier, thanks for the inspiration man ✨
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. 😅
Today I finally wanted to know what was the ChatGPT fuzz about. I just knew it was AI related. And as usual, Kevin explained it to me super easy. Thank you Kevin, you’re the best 👍 I don’t even go to other channels anymore, I know you have a very easy and *fast* answer.
Hello Kevin... I'm glad that you used the name of Bangladesh in example data. I am from Bangladesh and I'm a fan of you since you were an employee of Microsoft. Most of your videos are very helpful and increase productivity, so keep it up. Love from Bangladesh.
Assalamualaikum brother i wanted to do btech but because of some reason i couldn't my friend suggested me to invest money (10lakhs) on our family business (medical store) and i have done BSC and after COVID -19 businesses aren't working properly and I'm very depressed because all of my friends are earning money and I'm still stand there i withdrawal my seat without having any single class i had CS branch please tell me that if i do data analytics course what it will good for me ? And what is better way online or offline?
I have used this in office, gpt wrote a whole paragraph of excel formula which i entered into the cell and boom, it basically saved at-least a full day's work.
Brilliant! Your conclusion would be exactly my conclusion. Excel is not intimidating anymore. Thanks Kevin. And thanks Microsoft. Oh, and btw thanks for making your videos age restriction free. I can easily show this video to my daughter. You’re the man!
Kevin, your video '10X Your Excel Skills with ChatGPT' was a real eye-opener! It's amazing to see how ChatGPT can revolutionize our approach to Excel. Your tips and tricks are incredibly practical and easy to follow. I'm curious about how ChatGPT can be utilized for more complex Excel tasks, like predictive analytics or handling large datasets. Do you have any advice or advanced techniques for leveraging ChatGPT in these areas? Your insights could greatly benefit those of us looking to further enhance our Excel skills. Thanks for such an informative video!
What an era we are living in. It's hard for me to articulate how astonishing it is that from one month to the next an AI technology appears that changes the course of learning programs like excel. And improving the lives for everyone from novices to people who've been using the software for decades. Amazing!
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.
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.
just your suggestion made me try chat for a formula i could never figure out and after asking it a few times, getting my words specific and clear, it provided the exact formula needed. thanks for the suggestions
I’ve found chatGPT is also a very good network engineer. It can configure, troubleshoot, and maintain a network via command line interface for you. Just ask it what you want to do and it’ll give you the commands. It’s pretty crazy
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.
Thank you @Kevin, this has been helpful to me. I have no knowledge of Excel, and in my new job I work with spreadsheets. This makes it easier for me to learn how to use and run formulas in Excel. However, I still wanted to take a real Excel course.
I came to learn something and then saw a feature I never knew existed!! With the email ability using macros. Can you also add attachments to the emails? Can you also include variables in the email messages? For Instance. You owe X amount for "5" apples.
thats crazy! thanks for pointing this out! i think i'm pretty good at Excel, but you don't know what you don't know right? I'm gonna test out ChatGPT now and again with things I wish there was a shortcut for... because there probably is
Nice one Kevin. Thank you for the Video Tutorial. You said, If you're interested in learning about how to understand how macro works and even how to write your own macros, be sure to check out the video right up above, where I walk through a full tutorial of how you can create your very own macros in Excel. I have checked out the video right up above. I saw two Videos. 1.] Page Number in Word from Specific Page and 2.] How to Make Bar Chart in Excel. But None of the Two Videos talked about Macros. Yes, I am interested in learning about how to understand how Macro works and even how to write my Own macros. Give Link to a full tutorial of how I can create my very own macros in Excel. Kindly, reply me. Thank you.
🥷 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
📚 Article that walks through ChatGPT in Excel: 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: kevinstratvert.com/newsletter/
There is reports that MS is going to invest heavily in ChatGPT and also wanting to incorporate it into Bing and also Office Programmes
Kelvin I love you....... You are a life saver....💙
@@migram2051 yeah, $30 for lifetime access to all videos and training content 👍
Great video Kevin
Is chatgpt free version can create VBA codes ?? Please advise how did you able to create it
There seems to be a lot of hype about ChatGPT this week and month - seems well orchestrated. It is a bigger invasion of privacy than google as they are asking you for email AND phone number verified before you can even try it. No thanks. I am fine with duckduckgo.
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.
😮
Ha, good catch! I'm surprised our accountants didn't notice that big hole in the revenue from Bangladesh 🤣
@@KevinStratvert 🤣
Lol
😂😂😂Proof positive,,, programmers are going to do just fine.
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.
^^^ Nice try Bot using CGPT to write a self-serving comment. This stuff helps. But c'mon. The grifting/hysteria is strong with this one!
@@12345idiotsluggage exactly. Either a bot or someone ready to hand over their free will or humanity to their new master.
You both point out a potential integrity issue customer service. However, I always learned from Kevin’s videos and find them very useful to boost my own productivity and learn the limitless opportunities with automation and operational processes. But who am I right? Lol 😢
*formulas
@@you2449 its inevitable you cannot stop this technology
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!
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 ☺️
This is already old news, Copilot will replace anything that this guy knows or will know
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.
Chat GPT will replace him and every single teacher on earth
@@amateur_football9751 Chat GPT does not have a heart, though 😏.
It's a crucial part of a teacher
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.
Dude this makes things so much easier.
I am motivated by the simplicity in your tutorial. As an African (Nigerian) I can understand your English very well. I have a challenge in editing text and videos on CapCut. In one the length of text exceed the video. Also the space for the text in CapCut could not contain the text from ChapGPT. I should be glad to have your videos on these issues. 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.
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
ChatGPT looks like a great productivity and knowledge tool. Seems to me, there is 1 catch: ChatGPT makes small mistakes, and it takes real in-depth knowledge from the user to spot and tackle those mistakes. That's especially visible towards the end of the video, where Kevin manually corrects the Excel Macro code.
yeah that is true, but you can also ask ChatGPT if you don't understand something or you can ask ChatGPT to retry if there is a mistake or ask ChatGPT questions to find the error. That is a lot faster then learning an entire computer language.
Well, don't we ALL make mistakes? Doublecheck the work !
What a ride, after watching this video I hyperfocused for like 6 hours lol, I've never programmed for shit but I have okay logic, so I was able to create a super worksheet that can bulk insert images and resize them one per cell, automatically add the dates of the pictures, a menu to display all of the companies that I offer services to, and with a single click it creates the PDF, exactly how I needed for my reports, changes the title to the company name, opens outlook, creates an email to be send to them with custom header and body and the PDF already attached just waiting for me to press send. And a handy button to clean everything when I want to make another one (I fucking hated selecting images one by one in Excel to delete them lol I was dumb af). Now I'm excited to share this with my coworkers and make everybody's jobs easier, thanks for the inspiration man ✨
Have been using chatGPT for a while. It really helps. Thanks for making such videos.
Chat GPT is blowing my mind!!!! Cool to see real world scenarios being used.
I NEVER thought to use this for Excel before! Goodbye to constant If statement errors! Thank you so much!
One simple macro project of 30 minutes I have been doing from the past 3 year
Hope using this chatGPT I can complete my project 😀
What's especially cool is this works even if you don't even know if Excel can do what you're thinking.
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. 😅
Today I finally wanted to know what was the ChatGPT fuzz about. I just knew it was AI related. And as usual, Kevin explained it to me super easy. Thank you Kevin, you’re the best 👍 I don’t even go to other channels anymore, I know you have a very easy and *fast* answer.
What a simplistic and redundant video. I can Google every excel function, solution. ChatGPT is a useful function, but is antiquated at best.
Hello Kevin... I'm glad that you used the name of Bangladesh in example data. I am from Bangladesh and I'm a fan of you since you were an employee of Microsoft. Most of your videos are very helpful and increase productivity, so keep it up. Love from Bangladesh.
Assalamualaikum brother i wanted to do btech but because of some reason i couldn't my friend suggested me to invest money (10lakhs) on our family business (medical store) and i have done BSC and after COVID -19 businesses aren't working properly and I'm very depressed because all of my friends are earning money and I'm still stand there i withdrawal my seat without having any single class i had CS branch please tell me that if i do data analytics course what it will good for me ? And what is better way online or offline?
Todaaaaay........ i like the way you say it. thank you for the educational video
I used chat ai to write a macro today and then insert it into a button on each tab. It was positively beautiful 😍
I have used this in office, gpt wrote a whole paragraph of excel formula which i entered into the cell and boom, it basically saved at-least a full day's work.
I recently used it to write a Macro to help me complete time consuming tasks for my job
I e asked chatGPT to solve some complex issues on excel and it has provided what I needed to do and formulas too
Nice one. The main message is: Do not learn! No no!!! Just use!
Respect to all hard workers
My mind just blew up. This just changed my workflow.
Brilliant! Your conclusion would be exactly my conclusion. Excel is not intimidating anymore. Thanks Kevin. And thanks Microsoft. Oh, and btw thanks for making your videos age restriction free. I can easily show this video to my daughter. You’re the man!
Kevin, your video '10X Your Excel Skills with ChatGPT' was a real eye-opener! It's amazing to see how ChatGPT can revolutionize our approach to Excel. Your tips and tricks are incredibly practical and easy to follow. I'm curious about how ChatGPT can be utilized for more complex Excel tasks, like predictive analytics or handling large datasets. Do you have any advice or advanced techniques for leveraging ChatGPT in these areas? Your insights could greatly benefit those of us looking to further enhance our Excel skills. Thanks for such an informative video!
i'm convinced this guy is AI generated. No human talks like that
1000% non human
Definitely AI generated
Absolutely
Chatbot, please construct the apogee of bland, trendy, modernist, and non-threatening gamma male.
Would never have thought of using ChatGPT with excel, this is so cool!
It’s mind blowing with the OpenAI.
Your teaching method was brief and concise plus you also highlighted some excellent and vital tips that rarely known by others. Tq very much.
Excelformulabot utilizes GPT-3 for creating formulas. Super cool and well done.
Thanks for the video, Kevin!
Kevin sir I am a huge fan of yours from Dhaka, Bangladesh 🇧🇩🇧🇩🇧🇩🇧🇩
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 :)
Power Query is an interesting alternative already available in Excel.
What an era we are living in. It's hard for me to articulate how astonishing it is that from one month to the next an AI technology appears that changes the course of learning programs like excel. And improving the lives for everyone from novices to people who've been using the software for decades. Amazing!
Hi could probably go to chatGPT and tell it that macro gas mistake and what it does instead
This is something I'd expect Bulma to say...
Clear, concise, useful, and entertaining. Thanks Kevin.
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.
Love your NLP speaking. Nice tone. Less is more. Excellent! I appreciate the chat gpt videos. Thanks
Brilliant!
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.
This site is at capacity. Been waiting for a month now to get a change to test it out myself.
ChatGPT has saved so many times at work using Excel.
Kevin, loved this one. A similar video for MS Word would be great.
just your suggestion made me try chat for a formula i could never figure out and after asking it a few times, getting my words specific and clear, it provided the exact formula needed. thanks for the suggestions
Great job!
Kevin is right on time ‘again’ with the mic drop 🎤 Thank you x many.
Brilliant walkthrough! I find it easy to understand even if I'm not such a techy person. Thank you so much! Great help. :-)
I have been using it for vba programming as well as scripts in zmud, Going on 3 weeks now and my jaw just drops.
Awesome! I am so hooked on GPT recently. Think about basic annual income tax calculations!
Great job. Now even ChatGPT show how Excel is monstrous powerful...
This is what I need. Love ChatGPT. Thanks!
This is going to make a wonderful tool, Excel, actually usable by people who need only its basic features.
Love your tutorials Kevin 🎉 You’re my fav guy on the Internet 😅
The macro / vba example was great, the others seemed a bit forced in my opinion. Great channel, I love your material.
Nice video. ChatGpt has helped me a lot in my work since its release. People is mindblown by my excel skills they say 😂
Thanks so much for this video. I finally learned how macro is written and had ChatGPT wrote one for me.
I'm glad people are exploring how broken this software is so quickly!
VBA code for Email was impressive... anything i can integrate chatgpt in vba developer environment will be a big win
That was exciting, Kevin!
ExcelGPT here! Thank you for the content
I have learned so much from you!
my mind is blown 🤯, seems so powerful and I had no idea
This is incredible! I was taken abreast by the macros' section. Thank you @Kevin Stratvert. You are really amazing...
This thing is a game changer
Thanks bro. It just saved me in my office work
ChatGPT is a fantastic tool that is disrupting the way we do things! Thanks, Kevin for simplifying its use.
Absolutely amazing video dear Kevin.
Kevin, you are a great presenter! Keep up the videos!
I’ve found chatGPT is also a very good network engineer. It can configure, troubleshoot, and maintain a network via command line interface for you. Just ask it what you want to do and it’ll give you the commands. It’s pretty crazy
Thank-you so much for this video. It takes me to a much higher level in Excel and everything else.
Thanks Kevin. You 'excel' at showing how to use the latest technology in an easy-to-understand way. Much appreciated!
Amazing job Kevin. Loved the simplicity of the video
Good information! I love Chat GPT!!! It is truly AMAZING!!!
Agreed!
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.
Thanks Kevin. You showing how to use the latest technology in an easy to understand.
I like so many of your videos @kevin. This is yet another one. I never thought of Chat GPT for this.
this is awesome, i'm going to become a excel pro now CHEERS!
Go for it!
Astonishing content Man 👍👍👍
This is great! Never thought you could use chatgpt for this. Thank you!
Thank you @Kevin, this has been helpful to me. I have no knowledge of Excel, and in my new job I work with spreadsheets. This makes it easier for me to learn how to use and run formulas in Excel. However, I still wanted to take a real Excel course.
I came to learn something and then saw a feature I never knew existed!! With the email ability using macros. Can you also add attachments to the emails? Can you also include variables in the email messages? For Instance. You owe X amount for "5" apples.
Thanks for sharing this video, useful
thats crazy! thanks for pointing this out! i think i'm pretty good at Excel, but you don't know what you don't know right? I'm gonna test out ChatGPT now and again with things I wish there was a shortcut for... because there probably is
Nice work Kevin. I always enjoy your lectures and tutorials.
You are always excellent at delivering tasks and teaching materials.
Kevin, thanks a lot for your teaching. please, is it possible that you share with us the commands that you introduced into ChatGPT?
You are so close to 2M!! Congrasss... Hope you know about sheet GPT.
Great content, as always. Please keep the excel and ChatGPT videos coming!
Outstanding. Great material and you are a great teacher.
This is so revolutionary!!
Kevin, loved this one! A similar video for MS Word would be great. 🤓🤓
Hi kevin keep up the good work. i have learnt a lot through your videos
Always waiting for your videos.
Thank you! Another very helpful video!
Nice one Kevin. Thank you for the Video Tutorial.
You said, If you're interested in learning about how to understand how macro works and even how to write your own macros,
be sure to check out the video right up above, where I walk through a full tutorial of how you can create your very own macros in Excel.
I have checked out the video right up above. I saw two Videos. 1.] Page Number in Word from Specific Page and
2.] How to Make Bar Chart in Excel. But None of the Two Videos talked about Macros.
Yes, I am interested in learning about how to understand how Macro works and even how to write my Own macros. Give Link to a full tutorial of how I can create my very own macros in Excel.
Kindly, reply me.
Thank you.