Category Archives: Excel

Create Interactive Dashboards in Excel with Agent Mode

Tired of struggling with PivotTables, charts, and slicers to build dashboards in Excel? Thanks to Excel’s brand-new Agent Mode (aka Excel’s “AI Beast Mode”), creating an interactive dashboard has never been easier. In this step-by-step tutorial, I’ll show you how to use Agent Mode inside Excel Labs to automatically build a dashboard from raw dataContinue reading “Create Interactive Dashboards in Excel with Agent Mode”

Excel Just Got Smarter — Meet the NEW =COPILOT() Function

Excel just got a huge AI boost — the brand-new Copilot function lets you type =COPILOT directly into a cell, reference your data, and get instant answers or insights right in your spreadsheet. In this tutorial, I’ll walk you through: Whether you’re organizing feedback, summarizing data, or creating fun, dynamic content, Copilot in Excel canContinue reading “Excel Just Got Smarter — Meet the NEW =COPILOT() Function”

FREE Excel Tutoring (Powered by AI) — Learn Fast!

Ever wish you had a personal Excel tutor? With the new Copilot Vision in Windows, now you do—and it’s completely free. In this video, I’ll show you how to use Microsoft’s latest AI-powered assistant that actually sees your screen, understands your spreadsheet, and walks you through Excel tasks step by step. Whether you’re struggling withContinue reading “FREE Excel Tutoring (Powered by AI) — Learn Fast!”

Excel Tutoring for Beginners – Learn Formulas & Functions Step-by-Step

If Excel formulas and functions have ever confused you, you’re not alone. In this step-by-step tutorial, you’ll learn exactly how to use formulas and functions in Excel—even if you’re just getting started. We’ll cover: The difference between formulas and functions, how to perform calculations like sum, average, and max, the powerful IF function for logic,Continue reading “Excel Tutoring for Beginners – Learn Formulas & Functions Step-by-Step”

How to Use Power Query + Copilot to Instantly Import Data in Excel

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”

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

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 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)”