10X Your Excel Skills with ChatGPT 🚀

Подписаться 3 млн

Просмотров 3,3 млн

50% 1

🔥 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 RU-vid
ru-vid.com?...
🙌 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

Наука

Опубликовано:

15 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 823

@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 Год назад

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 Год назад

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

@KevinStratvert Год назад

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

@sharegoodthings8413 Год назад

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

@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 Год назад

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 Год назад

😮

@KevinStratvert Год назад

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

@expertfunda Год назад

@@KevinStratvert 🤣

@maziochendu5258 Год назад

Lol

@emangarrison Год назад

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

@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 Год назад

Chat GPT will replace him and every single teacher on earth

@Ofir306 Год назад

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

@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 Год назад

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

@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 Год назад

^^^ 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 Год назад

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

@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 Год назад

*formulas

@ferjim2804 Год назад

@@you2449 its inevitable you cannot stop this technology

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

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

@amazingtechtutorials2750 Год назад

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

@CommandoMaster Год назад

Dude this makes things so much easier.

@homymehta Год назад

Amazing job Kevin. Loved the simplicity of the video

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

@aditya_suresh Год назад

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

@rsearchtim Год назад

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

@RavenZamir Год назад

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

@aloksharma5468 Год назад

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

@davidcuff7496 Год назад

Kevin, thank you for all of you great videos.

@abiodunoshinowo2702 Год назад

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

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

@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

@rasraster Год назад

Outstanding. Great material and you are a great teacher.

@joanhatcher1083 Год назад

Thank you! Another very helpful video!

@jaymosint8792 Год назад

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

@mcwahaab Год назад

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

@ssaptaparni Год назад

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

@dolf1n1 Год назад

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

@freemanfgteevty6438 Год назад

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

@chewieonthefarm9332 Год назад

I have learned so much from you!

@travisrobison3457 Год назад

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

@elenahk7315 Год назад

Thank you Kevin for the tutorial

@bopeepespiritu7851 10 месяцев назад

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

@rajdeepmukherjee2021 Год назад

That was exciting, Kevin!

@valentinanorcross8830 Год назад

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

@isaacesaurg Год назад

Amazing! This got me really excited! Thanks man

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

@kenindenver1 Год назад

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

@fatimahhadi549 Год назад

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

@wilsontajaibanmoe5970 Год назад

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

@bennettdejoya2 11 месяцев назад

Thanks, Kevin! You make work so much easier.

@hbrannerudbrannerud6554 Год назад

Thanks, Kevin! Very informative! Keep it coming!

@asoliman9 Год назад

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

@bernardsunday9807 Месяц назад

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

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

@SimpleSheets Год назад

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

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

@ramausher3703 Год назад

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

@lovethatbeach Год назад

Amazing video. Learned a lot! Thanks a lot!

@rht100 Год назад

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

@dataanalyticssolutioninban4066 Год назад

You are always excellent at delivering tasks and teaching materials.

@philipoluwayemi3683 Год назад

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

@user-cu1yo7ty5j Год назад

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

@BBKMotoLove221 Год назад

This video was amazing. thank you Kevin.

@marcaldrinlascano2576 Год назад

Always waiting for your videos.

@moreloveandjoy Год назад

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

@nurattikah Год назад

Excellent tutorial. tq so much Kevin

@debbiewedoe2564 Год назад

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

@KarGar71 Год назад

Absolutely amazing video dear Kevin.

@rhonalkhairul3969 Год назад

Thanks for sharing this video, useful

@jackronald3591 Год назад

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

@EdHohlbein Год назад

Awesome as per usual! 👏

@rockochamp Год назад

I really enjoy your content Kevin

@sheheryarmohsin8215 Год назад

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

@AK-kl7pg Год назад

Excellent teacher! Thank you!

@momshiemomsh2968 Год назад

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.

@shanshanzhang5736 Год назад

It’s mind blowing with the OpenAI.

@jjs718 Год назад

Gonna try this in my work. Thanks.

@ernieramos2792 Год назад

Amazing! Thank you

@JDERX Год назад

I really love your videos, its very informative.

@StepByStepExcelTutorials 4 месяца назад

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

@firekidanbelay Год назад

This is what I need. Love ChatGPT. Thanks!

@RealtorStacie 6 месяцев назад

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

@Emrantamrin69 Год назад

Respect to all hard workers

@user-uo5oq9zc2c 10 месяцев назад

Thanks so much , I have learned so much

@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 😀

@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?

@dhaneshpt8641 12 дней назад

Great content and presentation. Thank you

@Goodgutgrub Год назад

So useful & great video! Ty

@jampatdes Год назад

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

@markandrow4010 Год назад

Thank you, excellent

@jennyhe31 Год назад

I like is all video, simple, short and easily understand.

@ravindra1206 Год назад

Nice information Kevin Thank you

@ahmadatef9469 Год назад

Thanks Kevin your videos are very helpful and easy to understand 💪

@KevinStratvert Год назад

Happy to hear that!

@dewanshbhajane7549 Год назад

Thanks bro. It just saved me in my office work

@yoshikagarner6655 Год назад

Good information! I love Chat GPT!!! It is truly AMAZING!!!

@KevinStratvert Год назад

Agreed!

@johnawuni8999 Год назад

That was a great education for free, thanks

@jomwanjestv Год назад

Thanks for the great content

@RedTech443 Год назад

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

@ravijha5777 2 месяца назад

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

@lensherman6242 Год назад

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

@GouravGupta-gc2vs Год назад

thanks..nicely expained.

@somagraphics Год назад

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

@simonfox4778 Год назад

Thank you. Cool stuff.

@MasterBrain182 Год назад

Astonishing content Man 👍👍👍

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

@GearsBusinessSolutions Месяц назад

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 Месяц назад

Great job!

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

@korenaxie682 Год назад

This is so revolutionary!!

@MrWisy19 Год назад

Todaaaaay........ i like the way you say it. thank you for the educational video

@faheemullah3117 Год назад

Sir Your Every video is Great ad very informative.Thanks

@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 Год назад

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.