10X Your Excel Skills with ChatGPT 🚀

Ғылым және технология

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
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: chat.openai.com/
- Excel workbook to follow along: 1drv.ms/x/s!AmxrofZZlZ-whYJ-s...
- Article that walks through ChatGPT in Excel: kevinstratvert.com/2023/01/18...
⌚ 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: • 5 Mind-blowing Artific...
- How to create simple macros in Excel: • How to Create Macros i...
- Full tutorial on Excel Macros and VBA: • Excel Macros & VBA - T...
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZread
kzread.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (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

Пікірлер: 818

  • @KevinStratvert
    @KevinStratvert Жыл бұрын

    🥷 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/

  • @RuskyTheaterBear

    @RuskyTheaterBear

    Жыл бұрын

    There is reports that MS is going to invest heavily in ChatGPT and also wanting to incorporate it into Bing and also Office Programmes

  • @ochuutv7195

    @ochuutv7195

    Жыл бұрын

    Kelvin I love you....... You are a life saver....💙

  • @KevinStratvert

    @KevinStratvert

    Жыл бұрын

    @@migram2051 yeah, $30 for lifetime access to all videos and training content 👍

  • @sharegoodthings8413

    @sharegoodthings8413

    Жыл бұрын

    Great video Kevin Is chatgpt free version can create VBA codes ?? Please advise how did you able to create it

  • @uncommonsense9973

    @uncommonsense9973

    Жыл бұрын

    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.

  • @BrianHurn
    @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.

  • @killer909Y

    @killer909Y

    Жыл бұрын

    😮

  • @KevinStratvert

    @KevinStratvert

    Жыл бұрын

    Ha, good catch! I'm surprised our accountants didn't notice that big hole in the revenue from Bangladesh 🤣

  • @expertfunda

    @expertfunda

    Жыл бұрын

    @@KevinStratvert 🤣

  • @maziochendu5258

    @maziochendu5258

    Жыл бұрын

    Lol

  • @emangarrison

    @emangarrison

    Жыл бұрын

    😂😂😂Proof positive,,, programmers are going to do just fine.

  • @Armen_
    @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.

  • @amateur_football9751

    @amateur_football9751

    Жыл бұрын

    Chat GPT will replace him and every single teacher on earth

  • @Ofir306

    @Ofir306

    Жыл бұрын

    @@amateur_football9751 Chat GPT does not have a heart, though 😏. It's a crucial part of a teacher

  • @nwinburn
    @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!

  • @epicstories07
    @epicstories07 Жыл бұрын

    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 ☺️

  • @amateur_football9751

    @amateur_football9751

    Жыл бұрын

    This is already old news, Copilot will replace anything that this guy knows or will know

  • @drdheerajtumu7419
    @drdheerajtumu7419 Жыл бұрын

    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.

  • @justinabosco2763
    @justinabosco2763 Жыл бұрын

    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. 😅

  • @amazingtechtutorials2750
    @amazingtechtutorials2750 Жыл бұрын

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

  • @aditya_suresh
    @aditya_suresh Жыл бұрын

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

  • @abiodunoshinowo2702
    @abiodunoshinowo2702 Жыл бұрын

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

  • @aloksharma5468
    @aloksharma5468 Жыл бұрын

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

  • @emilythechef
    @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.

  • @travisrobison3457
    @travisrobison3457 Жыл бұрын

    Chat GPT is blowing my mind!!!! Cool to see real world scenarios being used.

  • @homymehta
    @homymehta Жыл бұрын

    Amazing job Kevin. Loved the simplicity of the video

  • @tizme2311
    @tizme2311 Жыл бұрын

    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
    @rsearchtim Жыл бұрын

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

  • @CommandoMaster
    @CommandoMaster Жыл бұрын

    Dude this makes things so much easier.

  • @ssaptaparni
    @ssaptaparni Жыл бұрын

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

  • @RavenZamir
    @RavenZamir Жыл бұрын

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

  • @IMMediaChannel
    @IMMediaChannel Жыл бұрын

    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

  • @aspuzling
    @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.

  • @12345idiotsluggage

    @12345idiotsluggage

    Жыл бұрын

    ^^^ 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!

  • @you2449

    @you2449

    Жыл бұрын

    @@12345idiotsluggage exactly. Either a bot or someone ready to hand over their free will or humanity to their new master.

  • @youssoufahmed1788

    @youssoufahmed1788

    Жыл бұрын

    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 😢

  • @idcaf

    @idcaf

    Жыл бұрын

    *formulas

  • @ferjim2804

    @ferjim2804

    Жыл бұрын

    ​@@you2449 its inevitable you cannot stop this technology

  • @mcwahaab
    @mcwahaab Жыл бұрын

    Great content, as always. Please keep the excel and ChatGPT videos coming!

  • @valentinanorcross8830
    @valentinanorcross8830 Жыл бұрын

    Love your NLP speaking. Nice tone. Less is more. Excellent! I appreciate the chat gpt videos. Thanks

  • @kenindenver1
    @kenindenver1 Жыл бұрын

    Thanks Kevin. You 'excel' at showing how to use the latest technology in an easy-to-understand way. Much appreciated!

  • @davidcuff7496
    @davidcuff7496 Жыл бұрын

    Kevin, thank you for all of you great videos.

  • @larahporter8123
    @larahporter8123 Жыл бұрын

    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.

  • @moreloveandjoy
    @moreloveandjoy Жыл бұрын

    Kevin is right on time ‘again’ with the mic drop 🎤 Thank you x many.

  • @freemanfgteevty6438
    @freemanfgteevty6438 Жыл бұрын

    Thank-you so much for this video. It takes me to a much higher level in Excel and everything else.

  • @rasraster
    @rasraster Жыл бұрын

    Outstanding. Great material and you are a great teacher.

  • @user-cu1yo7ty5j
    @user-cu1yo7ty5j Жыл бұрын

    Thanks so much for this video. I finally learned how macro is written and had ChatGPT wrote one for me.

  • @bopeepespiritu7851
    @bopeepespiritu78519 ай бұрын

    Brilliant walkthrough! I find it easy to understand even if I'm not such a techy person. Thank you so much! Great help. :-)

  • @dkjb5756
    @dkjb5756 Жыл бұрын

    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 😀

  • @wilsontajaibanmoe5970
    @wilsontajaibanmoe5970 Жыл бұрын

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

  • @jaymosint8792
    @jaymosint8792 Жыл бұрын

    Love your tutorials Kevin 🎉 You’re my fav guy on the Internet 😅

  • @SimpleSheets
    @SimpleSheets Жыл бұрын

    Excelformulabot utilizes GPT-3 for creating formulas. Super cool and well done. Thanks for the video, Kevin!

  • @joanhatcher1083
    @joanhatcher1083 Жыл бұрын

    Thank you! Another very helpful video!

  • @parameswariramasamy6463
    @parameswariramasamy6463 Жыл бұрын

    Your teaching method was brief and concise plus you also highlighted some excellent and vital tips that rarely known by others. Tq very much.

  • @dolf1n1
    @dolf1n1 Жыл бұрын

    Great vids Kevin, clear, short, sharp and to the point! 👍

  • @rajdeepmukherjee2021
    @rajdeepmukherjee2021 Жыл бұрын

    That was exciting, Kevin!

  • @RealtorStacie
    @RealtorStacie5 ай бұрын

    I NEVER thought to use this for Excel before! Goodbye to constant If statement errors! Thank you so much!

  • @asoliman9
    @asoliman9 Жыл бұрын

    you earned a new subscriber for this video. Awesome! thanks for the helpful tips

  • @fatimahhadi549
    @fatimahhadi549 Жыл бұрын

    Thanks Kevin for this amazingly informative video.... Your teaching method is perfect.

  • @pillagingpirates8744
    @pillagingpirates8744 Жыл бұрын

    This video is so informative and well-produced. Keep up the great work. Can you do more videos with a Blue Willow comparison to other image AI generators?

  • @momshiemomsh2968
    @momshiemomsh296811 ай бұрын

    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.

  • @philipoluwayemi3683
    @philipoluwayemi3683 Жыл бұрын

    This is very insightful, I really love the Macros part. Thank you, thank you!

  • @rht100
    @rht10011 ай бұрын

    Kevin, you are a great presenter! Keep up the videos!

  • @justice929
    @justice929 Жыл бұрын

    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.

  • @bernardsunday9807
    @bernardsunday98074 күн бұрын

    Nice work Kevin. I always enjoy your lectures and tutorials.

  • @jackronald3591
    @jackronald3591 Жыл бұрын

    Thank you Kevin perfect guide!! have my chat account now and going back through some Excel's and updating formula's

  • @elenahk7315
    @elenahk7315 Жыл бұрын

    Thank you Kevin for the tutorial

  • @dataanalyticssolutioninban4066
    @dataanalyticssolutioninban4066 Жыл бұрын

    You are always excellent at delivering tasks and teaching materials.

  • @bennettdejoya2
    @bennettdejoya210 ай бұрын

    Thanks, Kevin! You make work so much easier.

  • @debbiewedoe2564
    @debbiewedoe2564 Жыл бұрын

    Awesome video. So much content. Value is huge. I have lots to play around with now. THANK YOU

  • @pwells2389
    @pwells2389 Жыл бұрын

    Fantastic vid. Amazing how far AI has come already. And as far as I know, it wasn't trained to learn Excel or other languages either. As an ex sw developer your last example was quite frankly alarming... in a good way.

  • @somagraphics
    @somagraphics Жыл бұрын

    This is great! Never thought you could use chatgpt for this. Thank you!

  • @chewieonthefarm9332
    @chewieonthefarm9332 Жыл бұрын

    I have learned so much from you!

  • @hbrannerudbrannerud6554
    @hbrannerudbrannerud655411 ай бұрын

    Thanks, Kevin! Very informative! Keep it coming!

  • @ramausher3703
    @ramausher3703 Жыл бұрын

    Thanks Kevin. You showing how to use the latest technology in an easy to understand.

  • @isaacesaurg
    @isaacesaurg Жыл бұрын

    Amazing! This got me really excited! Thanks man

  • @StepByStepExcelTutorials
    @StepByStepExcelTutorials3 ай бұрын

    Would never have thought of using ChatGPT with excel, this is so cool!

  • @marcaldrinlascano2576
    @marcaldrinlascano2576 Жыл бұрын

    Always waiting for your videos.

  • @BBKMotoLove221
    @BBKMotoLove221 Жыл бұрын

    This video was amazing. thank you Kevin.

  • @stevenw354
    @stevenw354 Жыл бұрын

    my mind is blown 🤯, seems so powerful and I had no idea

  • @GearsBusinessSolutions
    @GearsBusinessSolutions11 күн бұрын

    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

  • @KevinStratvert

    @KevinStratvert

    11 күн бұрын

    Great job!

  • @geerliglecluse5297
    @geerliglecluse5297 Жыл бұрын

    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.

  • @tucker8071

    @tucker8071

    Жыл бұрын

    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.

  • @wanderingsoul2909

    @wanderingsoul2909

    Жыл бұрын

    Well, don't we ALL make mistakes? Doublecheck the work !

  • @lovethatbeach
    @lovethatbeach Жыл бұрын

    Amazing video. Learned a lot! Thanks a lot!

  • @natalieharrison5202
    @natalieharrison5202 Жыл бұрын

    I used chat ai to write a macro today and then insert it into a button on each tab. It was positively beautiful 😍

  • @RedTech443
    @RedTech443 Жыл бұрын

    My mind just blew up. This just changed my workflow.

  • @sheheryarmohsin8215
    @sheheryarmohsin8215 Жыл бұрын

    Kevin, hats off dear! Good work; love you!

  • @EdHohlbein
    @EdHohlbein Жыл бұрын

    Awesome as per usual! 👏

  • @anoniem7062
    @anoniem7062 Жыл бұрын

    Holy macaroni! That is beyond amazing! Thanks for explaining and sharing! 🥳🥳

  • @dewanshbhajane7549
    @dewanshbhajane7549 Жыл бұрын

    Thanks bro. It just saved me in my office work

  • @dwaynE2099
    @dwaynE2099 Жыл бұрын

    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 :)

  • @cagnazzo82
    @cagnazzo82 Жыл бұрын

    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!

  • @mstefa007

    @mstefa007

    Жыл бұрын

    Hi could probably go to chatGPT and tell it that macro gas mistake and what it does instead

  • @thevisitor1012

    @thevisitor1012

    Жыл бұрын

    This is something I'd expect Bulma to say...

  • @KarGar71
    @KarGar71 Жыл бұрын

    Absolutely amazing video dear Kevin.

  • @rockochamp
    @rockochamp Жыл бұрын

    I really enjoy your content Kevin

  • @lukegrot
    @lukegrot Жыл бұрын

    Awesome video and links, I was able to run the Macro to send emails to myself!

  • @jampatdes
    @jampatdes Жыл бұрын

    This site is at capacity. Been waiting for a month now to get a change to test it out myself.

  • @AIforConsultants
    @AIforConsultants Жыл бұрын

    ExcelGPT here! Thank you for the content

  • @bradleybprentice1497
    @bradleybprentice1497 Жыл бұрын

    Awesome! I am so hooked on GPT recently. Think about basic annual income tax calculations!

  • @lensherman6242
    @lensherman6242 Жыл бұрын

    What's especially cool is this works even if you don't even know if Excel can do what you're thinking.

  • @MrVvrfly
    @MrVvrfly Жыл бұрын

    Excellent video. Thank you Kevin. Looking forward to have more.

  • @Zentabes
    @Zentabes Жыл бұрын

    Nice video. ChatGpt has helped me a lot in my work since its release. People is mindblown by my excel skills they say 😂

  • @nicholasodonnell9501
    @nicholasodonnell9501 Жыл бұрын

    What a simplistic and redundant video. I can Google every excel function, solution. ChatGPT is a useful function, but is antiquated at best.

  • @nurattikah
    @nurattikah Жыл бұрын

    Excellent tutorial. tq so much Kevin

  • @jjs718
    @jjs718 Жыл бұрын

    Gonna try this in my work. Thanks.

  • @sasavienne
    @sasavienne Жыл бұрын

    That is genius. Thank you so much for sharing this video. 🎉

  • @firekidanbelay
    @firekidanbelay Жыл бұрын

    This is what I need. Love ChatGPT. Thanks!

  • @NickWindham
    @NickWindham Жыл бұрын

    Great video. I have found check GPT to be especially helpful at creating advanced functions in excel.

  • @kristen374

    @kristen374

    Жыл бұрын

    Telegram 👇

  • @kristen374

    @kristen374

    Жыл бұрын

    @Jenny_Worldz06

  • @moulics
    @moulics Жыл бұрын

    that was awesome - excel made super simple

  • @rhonalkhairul3969
    @rhonalkhairul3969 Жыл бұрын

    Thanks for sharing this video, useful

  • @wandagreer9144
    @wandagreer9144 Жыл бұрын

    Kevin, both you and Chat are amazing! Thank you. But, I seem to have trouble putting the question together to achieve the complicated results I need. Is there any help for this?

  • @jerichosharman470
    @jerichosharman470 Жыл бұрын

    I e asked chatGPT to solve some complex issues on excel and it has provided what I needed to do and formulas too

  • @JDERX
    @JDERX Жыл бұрын

    I really love your videos, its very informative.

  • @ijacheddygraphic438
    @ijacheddygraphic4389 ай бұрын

    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. 👍

  • @ravijha5777
    @ravijha5777Ай бұрын

    grt man,,,hv been following u through years now

  • @faheemullah3117
    @faheemullah3117 Жыл бұрын

    Sir Your Every video is Great ad very informative.Thanks

  • @AK-kl7pg
    @AK-kl7pg11 ай бұрын

    Excellent teacher! Thank you!

  • @luisllontopbarahona3188
    @luisllontopbarahona3188 Жыл бұрын

    Thank you for sharing this wonderful tool, especially with the macros... Amazing job! Will check your video on macros... Do you know where I can find how to build macros using lattice model and montecarlo simulation? Thank you in advance for your time....

  • @R0bertP
    @R0bertP Жыл бұрын

    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!

Келесі