Thursday, May 22, 2025

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.

Tuesday, May 20, 2025

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.

Sunday, May 18, 2025

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.

Sunday, April 27, 2025

Excel Trick: Show Different Colors for Positive & Negative Values


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.

Tuesday, April 8, 2025

Make Your Spreadsheets Interactive: Add Checkboxes for Users


Whether you're juggling a packed to-do list, tracking project tasks, or building an interactive form for others to use, checkboxes are one of the simplest yet most powerful tools to keep things organized and visually clear. They help streamline your workflow, reduce clutter, and instantly show what’s done and what still needs attention. 

But here’s the part most people miss: adding checkboxes doesn’t have to be a slow, manual process. What if I told you there's a way to insert, customize, and even automate checkboxes in just a few clicks—without digging through menus or wasting time? That’s exactly what I’m going to show you in today’s video.

Whether you're a productivity nerd or just looking to make your digital life a little easier, you’ll learn the fastest method to add functional, professional-looking checkboxes with zero hassle. By the end of this tutorial, you’ll not only know how to drop them in effortlessly—you’ll also know how to tweak them for your needs and make them work *for* you, not the other way around.

Wednesday, April 2, 2025

Is the EXPAND Function Even Useful? Let’s Find Out!


EXPAND is supposed to help with data prep—but let’s be honest, do you really need it? In this video, I’ll break down exactly what EXPAND does, when (if ever) it’s actually useful, and whether it’s just another flashy function pretending to be helpful. By the end, you’ll know if it’s a hidden gem… or just spreadsheet noise.

Friday, March 28, 2025

How to Find Every Formula Cell in Excel – Quick & Simple


You open an Excel file, and someone has made changes—but now, the numbers aren’t adding up. How do you know which cells contain formulas and which are just values? Instead of manually checking each one (which would take forever), I’m going to show you some quick tricks to instantly reveal all formula cells in Excel. Whether you’re reviewing a report, debugging errors, or just sharpening your Excel skills, this tip will make your workflow so much smoother.