❎ How to use Excel

Currently Playing: Copilot Excel Tutorial - Excel’s Biggest Upgrade Ever

Microsoft Excel just got a game-changing upgrade with Copilot, your AI-powered assistant! In this video, I’ll show you how to leverage Copilot to write formulas, clean data, analyze feedback, generate charts, and even build full dashboards—all with simple prompts. If you've ever struggled with Excel functions or spent hours manually analyzing data, Copilot will revolutionize your workflow. In This Video, You’ll Learn: ✔️ How to enable & access Copilot in Excel ✔️ Automate tasks like filling in missing data & cleaning up spreadsheets ✔️ Generate formulas & advanced calculations effortlessly ✔️ Create interactive dashboards & charts with AI ✔️ Use Python in Excel for next-level data analysis Host: Kevin Stratvert 📚 RESOURCES - Sample Excel workbook to follow along: https://kevstrat-my.sharepoint.com/:x:/g/personal/admin_kevstrat_onmicrosoft_com/EZrFnuUdpRREj1o1bNVBBKABFMc5LXUiXqvAx4PPhf8q7A?e=FCJ7Zg ⌚ TIMESTAMPS 00:00 - Introduction to Excel Copilot 00:28 - How to Get Copilot 01:08 - Where to Find Copilot 01:58 - Automate Lookup Functions 04:56 - Clean Data 07:15 - Fill in Missing Data 07:41 - Extract Data 08:05 - Generate & Use Custom Formulas 08:27 - Apply Conditional Formatting 08:55 - Sort Data 09:29 - Filter Data 10:00 - Summarize Data 10:43 - Visualize Data with Charts 11:10 - Analyze Sentiment for Feedback Visualization 11:38 - Generate a Word Cloud with Python 13:39 - Build AI-Powered Dashboards with Python 14:48 - How to Enable Python in Excel 15:02 - Explore Copilot’s Prompt Gallery 15:55 - 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 #copilot