Pages

▼
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 gaslighti...
Sunday, April 27, 2025

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 col...
Tuesday, April 8, 2025

Make Your Spreadsheets Interactive: Add Checkboxes for Users

›
https://youtu.be/N-_asbWJuLk Whether you're juggling a packed to-do list, tracking project tasks, or building an interactive form for ot...
Wednesday, April 2, 2025

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

›
https://youtu.be/Pt5jFGg-TyA EXPAND is supposed to help with data prep—but let’s be honest, do you really need it? In this video, I’ll break...
Friday, March 28, 2025

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

›
https://youtu.be/D0qL6sYFlVw You open an Excel file, and someone has made changes—but now, the numbers aren’t adding up. How do you know whi...
Thursday, March 20, 2025

How to Use DROP & TAKE in Excel – Quick & Easy Guide

›
https://youtu.be/Qq-RRqxX1b4 Let's break down the TAKE & DROP, so you can start using these powerful Excel functions right away. So ...
Monday, March 3, 2025

How to Parse XML Files Easily Using Power Query

›
https://youtu.be/vywP0x9krGY XML files don’t have to be a headache anymore. If you’ve ever opened one and felt overwhelmed by all the tags a...