ImmersiveAmbientModecolor: #d2aeab (color 1)
Video Format : 22 (720p) openh264 ( https://github.com/cisco/openh264) mp4a.40.2 | 44100Hz
Audio Format: Opus - Normalized audio
PokeTubeEncryptID: b28d15fc6cdef56a1dd7953ad891aa7e0bfa4dbc2cbb6f51ca203c88d46b311a671290f66d34e430e83f9c87a2f3954b
Proxy : eu-proxy.poketube.fun - refresh the page to change the proxy location
Date : 1715518110015 - unknown on Apple WebKit
Mystery text : Sll0WjJ6c2RFX3MgaSAgbG92ICB1IGV1LXByb3h5LnBva2V0dWJlLmZ1bg==
143 : true
3,257,885 Views • Jan 12, 2023 • Click to toggle off description
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-sjcKPqzy6IZVYQ?e=H2FYX…
- Article that walks through ChatGPT in Excel: kevinstratvert.com/2023/01/18/10x-your-excel-skill…
⌚ 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 Artificial Intelligenc...
- How to create simple macros in Excel: • How to Create Macros in Excel Tutorial
- Full tutorial on Excel Macros and VBA: • Excel Macros & VBA - Tutorial for Beg...
📩 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: www.linkedin.com/in/kevinstratvert/
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: twitter.com/kevstrat
- Facebook: www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: www.tiktok.com/@kevinstratvert
- Instagram: www.instagram.com/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 YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
🙌 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
Views : 3,257,885
Genre: Science & Technology
Date of upload: Jan 12, 2023 ^^
Rating : 4.854 (1,859/49,080 LTDR)
RYD date created : 2024-05-11T13:34:50.989449Z
See in json
YouTube Comments - 819 Comments
Top Comments of this video!! :3
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.
698 |
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.
114 |
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.
43 |
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 ☺️
66 |
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.
4 |
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!
3 |
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.
7 |
Another great video Clear, concise, useful, and entertaining. Thanks Kevin.
4 |
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. 😅
2 |
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.
2 |
Great video, as always! Thanks for sharing these good ideas, Kevin!
5 |
Kevin, loved this one! A similar video for MS Word would be great. 🤓🤓
4 |
This is incredible! I was taken abreast by the macros' section. Thank you @Kevin Stratvert. You are really amazing...
|
Chat GPT is blowing my mind!!!! Cool to see real world scenarios being used.
2 |
Dude this makes things so much easier.
9 |
I like so many of your videos @kevin. This is yet another one. I never thought of Chat GPT for this.
2 |
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.
2 |
Amazing job Kevin. Loved the simplicity of the video
2 |
Thanks Kevin. You 'excel' at showing how to use the latest technology in an easy-to-understand way. Much appreciated!
3 |
@KevinStratvert
1 year ago
🥷 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-skill… 📩 Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
73 |