Power Query - COALESCE Operator (Shorten those formulas with a cool "mystery" operator)

Power Query - Import Fixed Width (Delimited) Files

Power Query - Avoid "Helper Queries" (+10 Cool Tricks)

Power Query - Sorting is Sometimes Pointless (VertiPaq Insights)

Power Query - Query Folding (The key to faster query execution)

Excel GROUPBY & PIVOTBY Functions - All You Need to Know (do they BEAT Pivot Tables? 🤔)

Excel: Use Indent to Extract Hierarchy Levels from Single-Column Hierarchy to Separate Columns

Power Query - Exact Match Lookups (1 Goal; 3 Methods)

Power Query - Faster & Easier Parameters

Think Fast, Talk Smart: Communication Techniques

Power Query - Dynamic Column Selection

Advanced Unpivoting Tricks in Power Query

High-Income Excel Skills Worth Learning in 2024 (Free File)

Reference an Intermediate Step from another Query | Power Query Tricks

Power Query - Alternate Group By Strategies

Microsoft Excel - 16 Features in 1 Project (Improving the User Experience)

Power Query - Parameters with Error Checking (with bonus tip)

Power Query - Data from Email Attachment

5 Excel Secrets You'll Be Embarrassed You Didn't Know

List.Accumulate in Power Query

Expand columns dynamically in Power Query (THE RIGHT WAY!) | Excel Off The Grid