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 chartsContinue reading “How to Use Power Query + Copilot to Instantly Import Data in Excel”
Tag Archives: Automate Excel with AI
VLOOKUP in Excel Made EASY with AI (No Formula Needed!)
Forget memorizing formulas—Excel Copilot now does the heavy lifting for you! In this video, I’ll show you how to use AI in Microsoft Excel to perform lookups without ever typing =VLOOKUP(…) or =XLOOKUP(…). You’ll learn how to:✅ Turn your data into structured tables✅ Use Copilot to connect tables with just plain English✅ Let AI insertContinue reading “VLOOKUP in Excel Made EASY with AI (No Formula Needed!)”
Excel’s Biggest Upgrade Ever – How to Use Copilot!
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 revolutionizeContinue reading “Excel’s Biggest Upgrade Ever – How to Use Copilot!”
Kevin Stratvert 