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: • How to use Microsoft Power Query
⌚ 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: • ❎ How to use Excel
📩 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: / kevinstratvert
Discord: https://bit.ly/KevinStratvertDiscord
Twitter: / kevstrat
Facebook: / kevin-stratvert-101912218227818
TikTok: / kevinstratvert
Instagram: / 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?...
🙌 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
Auf dieser Seite können Sie das Online-Video Excel Power Query + Copilot Tutorial mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Kevin Stratvert 03 April 2025 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 54,257 Mal angesehen und es wurde von 1 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
