Control Multiple Pivot Tables with One Slicer in Excel

https://youtu.be/b7hGDNyMWgw

Trying to filter multiple pivot tables in Excel at the same time—without losing your sanity? You’re not the only one. In this quick tutorial, I’ll show you how to use a slicer (a.k.a. Excel’s way of making filters way less painful) to sync filters across pivot tables automatically. No more toggling each one like it's 2003. Whether you're building dashboards for coworkers, clients, or your own peace of mind, this trick will save time and frustration. Perfect for anyone who's ever screamed, "Why won’t these pivot tables just talk to each other?!"

How to Delete Specific Characters in Power Query

https://youtu.be/W5q7D_sMoyo

Learn how to clean text data in Power Query using Text.Select and Text.Remove—no coding required. In this step-by-step Power Query tutorial, you’ll discover how to remove unwanted characters from text columns in Excel or Power BI. Whether you're dealing with extra spaces, special symbols, or strange characters from messy data imports, this video shows you how to clean it all up fast. We’ll cover how to use Text.Select and Text.Remove functions to streamline your data cleaning process and keep your queries running smoothly. Open Power Query and follow along—your spreadsheets will thank you.

Excel + M365 Copilot: First Impressions You NEED to See

https://youtu.be/LOHjjC3Mnak

Curious about how Microsoft 365 Copilot works in Excel? Here's what really happens when AI meets spreadsheets. In this video, I share my first hands-on experience using Copilot in Excel, exploring how it handles tasks like generating formulas, analyzing data, and suggesting insights—all with just a few prompts. It's not exactly magic, but it does make some of Excel’s most tedious tasks way easier. I’ll break down what worked, what felt clunky, and the moments that actually impressed me. If you’ve been wondering whether Copilot in Excel is worth using for real-world tasks or just another shiny feature you’ll ignore, this one’s for you.

Stop Using INDEX MATCH! Try This Two-Way XLOOKUP Trick Instead

https://youtu.be/TkncclDZliM

Want to do two-way lookups in Excel without getting tangled in helper columns or INDEX MATCH gymnastics? In this video, you’ll learn how to use XLOOKUP for advanced 2D lookups—referencing both rows and columns with one clean formula. We’ll walk through the XLOOKUP syntax, break down the logic step-by-step, and plug it into a real-world example using sales reports and financial data. Whether you're building dashboards or wrestling messy spreadsheets into submission, this trick will seriously upgrade your Excel skills—fast, accurate, no fluff.

Use This Excel Percent Trick to Save Time (PERCENTOF Guide)

https://youtu.be/5lpkoOtOCdk

Tired of calculating percentages in Excel like it's still 2004? In this quick tutorial, you'll master the "percent of total" formula in Excel—the one that shows what slice of the pie each value owns. No complex functions. No VBA. Just one smart formula that works across an entire column. Whether you're building reports, analyzing sales, or just need Excel to stop being a time thief, this five-minute fix is packed with practical tips that actually make a difference.

How to Use NETWORKDAYS.INTL with Custom Holidays in Excel (Even the Weir...

https://youtu.be/XAY6PU64KNE

Struggling to get Excel’s workday calculations right? If your NETWORKDAYS formula feels like it's gaslighting you, holidays are probably the culprit. In this video, you'll learn how to use NETWORKDAYS.INTL in Excel with any holiday list—yes, even bizarre ones like Grilled Cheese Day or your boss’s cat’s birthday. Whether you’re working with national holidays, company PTO schedules, or totally arbitrary days off, I’ll show you how to make Excel bend to your will. Perfect for project planners, HR analysts, or anyone tired of Excel giving them the cold shoulder on time math.

Excel Trick: Show Different Colors for Positive & Negative Values

https://youtu.be/eevGeQZHkSY

Want to instantly make your Excel charts more powerful and easier to read? Most Excel charts default to one color across the board — and that’s fine… until it isn’t. If you’re tracking profit and loss, temperature changes, or anything where up and down matters — you need visual contrast. And Excel actually makes it easier than you think — once you know where to click. 

I’ll walk you through two ways to assign dynamic colors to your chart. Whether you're building reports for a boss, presenting to clients, or just trying to make sense of your own data — this is one of those skills that will level up your charts.