VLOOKUP in Excel Made EASY with AI (No Formula Needed!)

VLOOKUP in Excel Made EASY with AI (No Formula Needed!)

Kevin Stratvert

55 лет назад

28,696 Просмотров

Forget memorizing formulas—Excel Copilot now does the heavy lifting for you! In this video, I’ll show you how to use AI in Microsoft Excel to perform lookups without ever typing =VLOOKUP(...) or =XLOOKUP(...).

You’ll learn how to:
✅ Turn your data into structured tables
✅ Use Copilot to connect tables with just plain English
✅ Let AI insert the correct function (like XLOOKUP) automatically
✅ Watch your data update dynamically—no extra effort needed

🍪 And yes, we’re doing it all with cookie data from the Kevin Cookie Company—because cookies make everything better, except on the web. 😄

Host: Kevin Stratvert

📚 RESOURCES
- Sample Excel file to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whpVH8tyv86BCU5yEag?e=ue7b45

⌚ TIMESTAMPS
0:00 - Introduction
0:13 - Why not do it manually
1:06 - Turn data into tables
2:21 - Open Copilot
3:24 - Type your prompt
3:44 - Preview results
4:28 - Auto-update in action
5:09 - Wrap up

📺 RELATED VIDEOS
- Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 📹 CapCut | https://bit.ly/installcapcut
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
✅ 💵 Quickbooks Online | https://bit.ly/intuitquickbooksonline
✅ 👥 Hubspot | https://hubspot.sjv.io/DKo6jb
✅ 📈 Semrush | https://bit.ly/semrush14dayfreetrial
✅ 🎥 Descript | https://get.descript.com/sf22jb63w2tx
✅ 🏓 Smartsheet | https://bit.ly/trysmartsheet

🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #excel #vlookup

Тэги:

#kevin_stratvert #vlookup_in_excel #how_to_use_vlookup_in_excel #excel_vlookup #xlookup_in_excel #excel_xlookup #how_to_use_xlookup_in_excel #microsoft_excel_copilot #excel_copilot_tutorial #ai_in_excel #excel_ai_lookup #excel_copilot_vlookup #excel_copilot_xlookup #how_to_use_ai_in_excel #excel_lookup_without_formula #excel_ai_tutorial #automate_excel_with_ai #excel_tutorial #microsoft_365 #excel_tips #kevin_cookie_company
Ссылки и html тэги не поддерживаются


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