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.