❎ How to use Excel

Currently Playing: Excel Power Query + Copilot Tutorial

Learn how to use Power Query and Copilot together in Microsoft Excel to import, transform, and sync data like a pro! In this step-by-step tutorial, I’ll show you how to: ✔️ Pull live exchange rate data from the web ✔️ Automatically calculate prices in multiple currencies ✔️ Analyze your calendar and meeting data from Outlook ✔️ Fetch org charts from your company directory ✔️ Import and sync data from other Excel files with Power Query ✔️ Use simple Copilot prompts to automate everything Whether you're working with spreadsheets, web content, internal company data, or calendar events, Excel Copilot + Power Query makes it incredibly easy to get the data you need—fast. Host: Kevin Stratvert 📚 RESOURCES - How to use Microsoft Power Query: https://youtu.be/0aeZX1l4JT4 ⌚ TIMESTAMPS 0:00 - Introduction 0:27 - Import web data 1:52 - Convert Prices to Local Currencies 3:57 - Bring in data from internal files and emails 5:28 - Fetch org data from Azure Active Directory 6:09 - Pull in data from other Excel files with Power Query 7:55 - Keep external Excel data in sync automatically 8:29 - 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 #powerquery #copilot