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
On this page of the site you can watch the video online Excel Power Query + Copilot Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Kevin Stratvert 03 April 2025, share the link with friends and acquaintances, this video has already been watched 54,257 times on youtube and it was liked by 1 thousand viewers. Enjoy your viewing!
