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”
Category Archives: Microsoft
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!)”
🔓 Locked out of your Excel sheet or workbook? Don’t worry—I’ve got you covered.In this video, I’ll show you step-by-step how to unprotect an Excel sheet or workbook—even if you don’t know the password. No third-party tools, no coding—just a clever trick using built-in Windows and Excel features. 📁 What you’ll learn: 🍪 Bonus: OnceContinue reading
Grammarly vs. Free AI Tools: Do you still need it?
AI tools like ChatGPT and Copilot are changing how we write, but is Grammarly still worth it in 2025? Sign up and download Grammarly for FREE. If you want to level up your writing, upgrade to Pro with 20% off my link: http://grammarly.com/kevinstratvert03 In this video, I put all three tools to the test —Continue reading “Grammarly vs. Free AI Tools: Do you still need it?”
Top 5 AI Tools in 2025 – Increase Your Productivity!
The Future of AI is Here! Explore 5 revolutionary AI tools designed to enhance productivity, spark creativity, automate tedious tasks, and optimize your workflow. Whether you’re a professional, entrepreneur, or creative, these cutting-edge tools will transform the way you work. Host: Elizabeth Parker
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!”
How to Make Table of Contents in Microsoft Word (Automatically!) 📖✨
Want to make your documents more organized and professional? In this step-by-step tutorial, I’ll show you how to create an automatic Table of Contents in Microsoft Word—no manual updates needed! What You’ll Learn:✅ How to insert a Table of Contents in Word✅ How to apply heading styles to structure your document✅ How to update yourContinue reading “How to Make Table of Contents in Microsoft Word (Automatically!) 📖✨”
How to Create Drop Down List in Excel (2025)
Learn how to create dropdown lists in Excel to make data entry faster, more accurate, and user-friendly. This tutorial covers everything from basic dropdown lists to dynamic lists that automatically update when you add or remove items. Whether you’re making an order form, a project tracker, or a data validation system, Excel’s dropdown feature canContinue reading “How to Create Drop Down List in Excel (2025)”
How to Make Automated Data Entry Form in Excel
Want to automate data entry in Excel? In this step-by-step tutorial, I’ll show you how to create a sleek and professional automated data entry form that makes collecting responses effortless! What You’ll Learn:✔️ Design a user-friendly form with text fields, checkboxes, drop-downs, and a submit button✔️ Apply conditional formatting and data validation to control input✔️Continue reading “How to Make Automated Data Entry Form in Excel”
Microsoft SharePoint Tutorial (2025)
Discover how to harness the full potential of Microsoft SharePoint in this comprehensive step-by-step tutorial! Whether you’re new to SharePoint or looking to deepen your understanding, this video covers everything you need to know to get started. Learn how to navigate the SharePoint Start Page, create team and communication sites, manage documents, collaborate with teammates,Continue reading “Microsoft SharePoint Tutorial (2025)”
Kevin Stratvert 