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
Nesta página do site você pode assistir ao vídeo on-line Excel Power Query + Copilot Tutorial duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Kevin Stratvert 03 Abril 2025, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 54,257 vezes e gostou 1 mil espectadores. Boa visualização!
