Don’t Use the PERCENTOF Function in Excel Until You Watch This!

The NEW way to remove blank rows in Excel... ZERO CLICKS!!! 💥

Power Query Trick: Instantly Remove All Null Columns! 💥

Power Query Trick: Combine Excel Files with DIFFERENT Sheet Names! 🔥

Excel’s Ultimate FILTER Hack - Multiple Columns, Multiple Values 😲

SCAN Solves Advanced Excel Problems in a Single Cell

Unpivot with Formulas in Excel... No Power Query!!

Automate Power Query with VBA - Taking Power Query to the Next Level

The FASTEST Way to Unstack Data in Power Query? 3 Methods Compared

Custom Sorting with Excel formulas - Taking SORTBY to the next level!

Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query

Stop Excel calculating blank cells as zero

Dynamically insert blank rows between items in Excel | Make your analysis easier to read.

NEW Excel Function - TRIMRANGE: I Thought We Didn't Need It... I Was Wrong!

Is GROUPBY better than PivotTables? How to calculate Period, YTD and Full Year Projection

GROUPBY in Excel with dynamic drill down... Yes, it's possible.

GROUPBY with Multiple Tables in Excel – The Ultimate Guide!

Budget vs Actual with GROUPBY & PIVOTBY - SUPERCHARGE your reporting!

Using Flexible Functions in Excel (only for advanced users).

The BEST Way to Calculate Moving Averages in Excel with Dynamic Arrays

Allow ONLY 1 person to edit a cell - The awesome Excel feature you didn't know existed!

Excel Conditional Formatting Formulas - Format Like a Pro

Complete report in Excel with just ONE formula!

Dynamic array total rows that move automatically? Watch this!

The TRUTH about Filter - Advanced filter techniques in Excel and Power Query

Excel Multiple Column Lookups: Which Method is Best?

Stop manual work in Excel with this blueprint.

Supercharge Excel: Build Your Custom Function Library in Minutes!

DOUBLEXLOOKUP... the Excel function you've been waiting for!

Even easier than easiest - Multi Level Dependent Drop Down Lists