Power Query Tips: Remove These Things

Power Query vs Formulas vs PivotTables: When to Use Each

Why Did I Stop Using This Excel Trick? Enter Formulas With Short Codes

The Excel Pagination Trick That Makes Reports Unlimited

Power Query's "Advanced" Options Aren't Advanced

Excel's AGGREGATE Function Doesn't Work Like You Think

How to Keep Manual Changes with Power Query... It's Easy When You Know How!

The Best Lookup Function Nobody Talks About... FILTER

The SECRET Power Query Fix You've Been Waiting For

One Column Change Destroys Everything... Unless You Do This!

Make Formatting Move With Dynamic Arrays - NEW Spill Manager for Excel

The Colon Character Does More Than You Think - Advanced Excel Trick

Merge & Split PDFs For Free - Using Tools You Already Have

ONE CLICK: Convert Merged Cells to Center Across Selection Across the Entire Workbook

Power Query Secrets - Simple tweaks is all it takes.

Unpivot Multiple Header Rows in Excel (Faster Method)

HELP! Power Query Didn't Refresh... Or Did It?

The Zero Click Dream - Make Excel Do Your Work While You Sleep

Built Your Own Tools with Office Scripts to Automate Excel Tasks

Automate Excel with Loops in Office Scripts

Automate Excel with Office Scripts - Start Here

Drop‑Down Lists From Tables: Stop Using INDIRECT (Do This Instead)

Table Structured References Aren’t Hard — You’re Using Them Wrong

Excel Trick: Get the Address Behind a Hyperlink

Excel Checkboxes... More Powerful Than You Think

One Excel Report. Infinite Views. Here’s How.

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! 🔥