Formulas vs PivotTables vs Power Pivot: Which You Should Use (and When)?

Put Excel into easy mode by implementing First Normal Form.

Fix your slow Power Query refresh from SharePoint (700% faster)

These 5 Custom Column Tricks Make Power Query Easier

Excel's GROUPBY Function Has Hidden Features That Nobody Knows

Do This with Excel to Actually Save Time in 2026

10 Best New Excel Features of 2025

Excel Functions That Behave Like Values - This Is Mind Blowing 🤯

VLOOKUP vs XLOOKUP in Excel - Which Is Best?

FILTER + Wildcards in Excel: The NEW and BETTER Techniques

Calculate Payback Period in Excel - Know When You'll Get Your Money Back.

The Excel Lookup Battle: FILTER Takes on XLOOKUP... Who Will Win!!!

The Advanced Excel Method Nobody Told You About [The DROP REDUCE LAMBDA STACK Combo]

Why Your Excel Formula WON’T Spill - Solving the #VALUE error.

Why Excel Solutions On YouTube Don't Work For You!

The Reverse COUNTIFS Method to Check for Existence.

Tricky Unpivoting Problem... SOLVED: How to Unpivot Paired Columns in Power Query

Excel GROUPBY Problem Solved: Sort Months the Right Way

The Excel team kept this SECRET... GROUPBY does more than we think!

Excel Slicers WITHOUT PivotTables? The Disconnected Table Trick

Approximate Match in Power Query – The FASTEST Way Revealed!

Reduce Steps in Power Query - Tips Only the Pros Know!

Avoid Power Query Failures: The Smart Way to Manage Column Names

How I Made Excel Do My Work (Achieve the Zero Click Dream)

List.Buffer: This One Power Query Function Can Speed Up Your Refresh

LAMBDA Explained in Simple Terms - Excel’s Most Confusing Function... Finally Made Easy

The NEW way to fill down over blanks in Excel 💥

How Microsoft Will Fix Excel with Compatibility Versions - New Feature

All Combinations from Two Tables in Excel - Advanced Formula Magic

New Excel Features: Bulk send email & create PDFs directly in Excel (without VBA)

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