10X Your Excel Skills with ChatGPT 🚀

  Рет қаралды 3,368,121

Kevin Stratvert

Kevin Stratvert

Күн бұрын

Пікірлер: 833
@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.
@DieterF
@DieterF Жыл бұрын
Thanks!
@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.
@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!
@CommandoMaster
@CommandoMaster Жыл бұрын
Dude this makes things so much easier.
@aspzx
@aspzx Жыл бұрын
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
@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.
@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.
@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
@KenyaOnlineTv1
@KenyaOnlineTv1 Жыл бұрын
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
@MrWisy19
@MrWisy19 Жыл бұрын
Todaaaaay........ i like the way you say it. thank you for the educational video
@gorgeluis
@gorgeluis Жыл бұрын
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 ✨
@victorsuarez5620
@victorsuarez5620 Жыл бұрын
Power Query is an interesting alternative already available in Excel.
@rajdeepmukherjee2021
@rajdeepmukherjee2021 Жыл бұрын
That was exciting, Kevin!
@YaNykyta
@YaNykyta Жыл бұрын
Nice one. The main message is: Do not learn! No no!!! Just use!
@aloksharma5468
@aloksharma5468 Жыл бұрын
Have been using chatGPT for a while. It really helps. Thanks for making such videos.
@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
@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
@Emrantamrin69
@Emrantamrin69 Жыл бұрын
Respect to all hard workers
@marcaldrinlascano2576
@marcaldrinlascano2576 Жыл бұрын
Always waiting for your videos.
@shanshanzhang5736
@shanshanzhang5736 Жыл бұрын
It’s mind blowing with the OpenAI.
@elenahk7315
@elenahk7315 Жыл бұрын
Thank you Kevin for the tutorial
@MasterBrain182
@MasterBrain182 Жыл бұрын
Astonishing content Man 👍👍👍
@korenaxie682
@korenaxie682 Жыл бұрын
This is so revolutionary!!
@RealtorStacie
@RealtorStacie Жыл бұрын
I NEVER thought to use this for Excel before! Goodbye to constant If statement errors! Thank you so much!
@ijacheddygraphic438
@ijacheddygraphic438 Жыл бұрын
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. 👍
@jampatdes
@jampatdes Жыл бұрын
This site is at capacity. Been waiting for a month now to get a change to test it out myself.
@chewieonthefarm9332
@chewieonthefarm9332 Жыл бұрын
I have learned so much from you!
@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 !
@GearsBusinessSolutions
@GearsBusinessSolutions 7 ай бұрын
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 7 ай бұрын
Great job!
@KarGar71
@KarGar71 Жыл бұрын
Absolutely amazing video dear Kevin.
@StepByStepExcelTutorials
@StepByStepExcelTutorials 11 ай бұрын
Would never have thought of using ChatGPT with excel, this is so cool!
@shaswatmjha
@shaswatmjha 10 ай бұрын
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.
@travisrobison3457
@travisrobison3457 Жыл бұрын
Chat GPT is blowing my mind!!!! Cool to see real world scenarios being used.
@rhonalkhairul3969
@rhonalkhairul3969 Жыл бұрын
Thanks for sharing this video, useful
@bernardsunday9807
@bernardsunday9807 7 ай бұрын
Nice work Kevin. I always enjoy your lectures and tutorials.
@gm_stellaartois395
@gm_stellaartois395 Жыл бұрын
i'm convinced this guy is AI generated. No human talks like that
@kylewasyliw
@kylewasyliw 9 ай бұрын
1000% non human
@rawpotatofella9654
@rawpotatofella9654 7 ай бұрын
Definitely AI generated
@RocheSur
@RocheSur 5 ай бұрын
Absolutely
@paulocorrea521
@paulocorrea521 Ай бұрын
Chatbot, please construct the apogee of bland, trendy, modernist, and non-threatening gamma male.
@isaacesaurg
@isaacesaurg Жыл бұрын
Amazing! This got me really excited! Thanks man
@rht100
@rht100 Жыл бұрын
Kevin, you are a great presenter! Keep up the videos!
@sheheryarmohsin8215
@sheheryarmohsin8215 Жыл бұрын
Kevin, hats off dear! Good work; love you!
@partsdave8943
@partsdave8943 Жыл бұрын
I recently used it to write a Macro to help me complete time consuming tasks for my job
@JasonFolkerts
@JasonFolkerts Жыл бұрын
At 2:34, ChatGPT apparently made a spelling error. It wrote 'seperated' instead of 'separated'.
@sushantsuman0001
@sushantsuman0001 24 күн бұрын
😂😂😂
@AIforConsultants
@AIforConsultants Жыл бұрын
ExcelGPT here! Thank you for the content
@lensherman6242
@lensherman6242 Жыл бұрын
What's especially cool is this works even if you don't even know if Excel can do what you're thinking.
@MuhammadYasinChaudhry
@MuhammadYasinChaudhry Жыл бұрын
Great intro video. Thanks
@rockochamp
@rockochamp Жыл бұрын
I really enjoy your content Kevin
@ZestyLemonBoi
@ZestyLemonBoi Жыл бұрын
Brilliant!
@jesus.moreno
@jesus.moreno Жыл бұрын
wouuuuuuuuuuuuuuuuu .... yuo are awesome man ... muchas gracias Kevin!
@AK-kl7pg
@AK-kl7pg Жыл бұрын
Excellent teacher! Thank you!
@saifsms91
@saifsms91 Жыл бұрын
Nice Explanation :)
@amitavasaha7522
@amitavasaha7522 Жыл бұрын
Kevin sir I am a huge fan of yours from Dhaka, Bangladesh 🇧🇩🇧🇩🇧🇩🇧🇩
@deciphrai
@deciphrai Жыл бұрын
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.
@chrishellmax
@chrishellmax Жыл бұрын
I have been using it for vba programming as well as scripts in zmud, Going on 3 weeks now and my jaw just drops.
@SRINIVASSATYANARAYANA-sf8qr
@SRINIVASSATYANARAYANA-sf8qr 3 ай бұрын
Hi kevin keep up the good work. i have learnt a lot through your videos
@nurattikah
@nurattikah Жыл бұрын
Excellent tutorial. tq so much Kevin
@ramausher3703
@ramausher3703 Жыл бұрын
Thanks Kevin. You showing how to use the latest technology in an easy to understand.
@SimpleSheets
@SimpleSheets Жыл бұрын
Excelformulabot utilizes GPT-3 for creating formulas. Super cool and well done. Thanks for the video, Kevin!
@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.
@陳查理-c2c
@陳查理-c2c Жыл бұрын
Thanks so much for this video. I finally learned how macro is written and had ChatGPT wrote one for me.
@GouravGupta-gc2vs
@GouravGupta-gc2vs Жыл бұрын
thanks..nicely expained.
@analog_ape
@analog_ape Жыл бұрын
Really cool, thanks!
@KevinStratvert
@KevinStratvert Жыл бұрын
Glad you liked it!
@mmosecrets68
@mmosecrets68 Жыл бұрын
thank you for sharing wonderful contents
@stevenw354
@stevenw354 Жыл бұрын
my mind is blown 🤯, seems so powerful and I had no idea
@Goodgutgrub
@Goodgutgrub Жыл бұрын
So useful & great video! Ty
@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 :)
@RedTech443
@RedTech443 Жыл бұрын
My mind just blew up. This just changed my workflow.
@sarwathamdy
@sarwathamdy Жыл бұрын
💥💥💥You are amazing 💥💥💥
@ravindra1206
@ravindra1206 Жыл бұрын
Nice information Kevin Thank you
@LogAnalyzerAI
@LogAnalyzerAI 11 ай бұрын
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!
@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 😍
@hbrannerudbrannerud6554
@hbrannerudbrannerud6554 Жыл бұрын
Thanks, Kevin! Very informative! Keep it coming!
@johnawuni8999
@johnawuni8999 Жыл бұрын
That was a great education for free, thanks
@neerajkapoor1050
@neerajkapoor1050 Жыл бұрын
VBA code for Email was impressive... anything i can integrate chatgpt in vba developer environment will be a big win
@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 😀
@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. 😅
@_1mm
@_1mm Жыл бұрын
amazing video and just sub !! thanks!!
@RavenZamir
@RavenZamir Жыл бұрын
Clear, concise, useful, and entertaining. Thanks Kevin.
@homymehta
@homymehta Жыл бұрын
Amazing job Kevin. Loved the simplicity of the video
@jjs718
@jjs718 Жыл бұрын
Gonna try this in my work. Thanks.
@Jderx
@Jderx Жыл бұрын
I really love your videos, its very informative.
@joanhatcher1083
@joanhatcher1083 Жыл бұрын
Thank you! Another very helpful video!
@andrephillips7764
@andrephillips7764 Жыл бұрын
This thing is a game changer
@dhaneshpt8641
@dhaneshpt8641 6 ай бұрын
Great content and presentation. Thank you
@neiljk1
@neiljk1 Жыл бұрын
Wow. This could be a game changer.
@wilsontajaibanmoe5970
@wilsontajaibanmoe5970 Жыл бұрын
Kevin, loved this one. A similar video for MS Word would be great.
@moulics
@moulics Жыл бұрын
that was awesome - excel made super simple
@jacquelynjones6364
@jacquelynjones6364 Жыл бұрын
Wowzers! Thank you
@bennettdejoya2
@bennettdejoya2 Жыл бұрын
Thanks, Kevin! You make work so much easier.
@Jenny-q8g7s
@Jenny-q8g7s Жыл бұрын
Thanks so much , I have learned so much
@valentinanorcross8830
@valentinanorcross8830 Жыл бұрын
Love your NLP speaking. Nice tone. Less is more. Excellent! I appreciate the chat gpt videos. Thanks
@ernieramos2792
@ernieramos2792 Жыл бұрын
Amazing! Thank you
@anoniem7062
@anoniem7062 Жыл бұрын
Holy macaroni! That is beyond amazing! Thanks for explaining and sharing! 🥳🥳
@firekidanbelay
@firekidanbelay Жыл бұрын
This is what I need. Love ChatGPT. Thanks!
@gregnixon1296
@gregnixon1296 Жыл бұрын
This is going to make a wonderful tool, Excel, actually usable by people who need only its basic features.
@bopeepespiritu7851
@bopeepespiritu7851 Жыл бұрын
Brilliant walkthrough! I find it easy to understand even if I'm not such a techy person. Thank you so much! Great help. :-)
@steffensandyanaksaitkpm-gu9801
@steffensandyanaksaitkpm-gu9801 Жыл бұрын
Fantastic vid...good sharing
@mortician6
@mortician6 Жыл бұрын
this is awesome!
@philipoluwayemi3683
@philipoluwayemi3683 Жыл бұрын
This is very insightful, I really love the Macros part. Thank you, thank you!
@suwaibahbintisulaimankpm-g5515
@suwaibahbintisulaimankpm-g5515 Жыл бұрын
Thank you for sharing good ideas..
@iqbalimam2046
@iqbalimam2046 Жыл бұрын
teaching method is perfect
How to Create Pivot Table in Excel
20:49
Kevin Stratvert
Рет қаралды 1,4 МЛН
She made herself an ear of corn from his marmalade candies🌽🌽🌽
00:38
Valja & Maxim Family
Рет қаралды 18 МЛН
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 700 М.
BAYGUYSTAN | 1 СЕРИЯ | bayGUYS
36:55
bayGUYS
Рет қаралды 1,9 МЛН
30 ChatGPT Hacks You Need to Know in 2024 (Become a PRO!)
23:04
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 960 М.
ChatGPT Tutorial for Developers - 38 Ways to 10x Your Productivity
28:13
Programming with Mosh
Рет қаралды 3,5 МЛН
Don't Use ChatGPT Until You Watch This Video
13:40
Leila Gharani
Рет қаралды 1,8 МЛН
Excel Formulas and Functions | Full Course
52:40
Kevin Stratvert
Рет қаралды 1,6 МЛН
10 ChatGPT Life Hacks - THAT’LL CHANGE YOUR LIFE !!
11:00
Hayls World
Рет қаралды 2,7 МЛН
ChatGPT Tutorial: How to Use Chat GPT For Beginners 2024
27:51
Charlie Chang
Рет қаралды 3,4 МЛН
Copilot in Excel: Hype or Future?
12:27
Kevin Stratvert
Рет қаралды 207 М.
99% of Beginners Don't Know the Basics of AI
10:12
Jeff Su
Рет қаралды 540 М.
She made herself an ear of corn from his marmalade candies🌽🌽🌽
00:38
Valja & Maxim Family
Рет қаралды 18 МЛН