02:46

Mastering Powerful Regex Functions: Excel Challenge 05

04:27

Extract Emails Using REGEXEXTRACT: Excel Challenge 04

02:29

Master HIDDEN Dynamic Replacement Technique - Power Query Challenge 56

02:21

Split Text Like a Pro! - Power Query Challenge 55

05:09

Clean & Organize Data Like a Pro! - Power Query Challenge 54

03:37

Understanding Lists, Records & Tables Like a Pro! Power Query Basics

02:08

Summarize Messy Data Easily - Power Query Challenge 53

02:08

Extract Text Using TEXTBEFORE & TEXTAFTER: Excel DAF Challenge 03

04:54

Ranking Data with GROUPBY, SEQUENCE functions: Excel DAF Challenge 02

03:07

Rank and Group Data Like a Pro - Power Query Challenge 52

03:33

Reshape Rows into Columns - Power Query Challenge 51

02:59

RESHAPING Tables with TOCOL and WRAPROWS: Excel DAF Challenge 01

03:07

Transform One Messy Column into a Perfect Table - Power Query Challenge 50

03:30

Shared Drive Full? Power Query to the Rescue!

02:04

Group Every N Rows - Power Query Challenge 49

03:34

Running Totals with a Condition - Power Query Challenge 48

03:01

Group Customers by Month - Power Query Challenge 47

03:13

Transpose, Pivot, and Unpivot in 3 MINUTES! Power Query Guide

03:14

Power Query or Excel? The Rounding Issue You Didn't See Coming!

02:49

The Smart Way to Remove Duplicate Rows That Offset - Power Query Challenge 46

04:49

Power Query Partial Lookup: Automate Text Categorization Like a Pro in 5 MINUTES!

03:33

Test Grading Process - Power Query Challenge 45

02:28

How to Group Data by Quarters - Power Query Challenge 44

03:14

The Power Query Fix You Didn’t Know You Needed

02:25

Consecutive Grouping - Power Query Challenge 43

05:00

Advanced Conditional Splitting - Power Query Challenge 42

02:30

Extracting the Last Entry in Groups - Power Query Challenge 41

05:00

How to Extract Information from Text - Power Query Challenge 40

03:30

Clean Up Data with Conditional Replacement - Power Query Challenge 39

03:03

How to Use Advanced Grouping - Power Query Challenge 38

07:23

Master VBA: Save Excel Sheets as Separate Files in One Click!

02:39

Excel's Hidden Gem: Turn Pivot Filters into Individual Sheets!

04:59

Combine Data from EVERY Folder, File & Sheet with Power Query in 5 MINUTES!

01:50

STOP Struggling with Power Query Auto-Complete and Try This Instead!

02:30

How to Split & Pivot Data with Ease - Power Query Challenge 37

03:01

Make Running Totals in Power Query 12x Faster With This Hack

03:08

Calculate Quarter-To-Date in Excel: The Step-by-Step Guide

02:06

The FASTEST Way to Remove Empty Columns in Excel Power Query!

02:22

Extract the First Row of Each Group - Power Query Challenge 36

01:55

Excel 365 vs Power Query: Unstacking Data in a Few Clicks

03:21

Header Mapping Technique I Wish I Knew Sooner: Power Query Guide

03:09

Mastering Data Normalization - Power Query Challenge 35

03:43

Introducing TRIMRANGE Function: Excel 365 Insider (NEW!)

03:12

Power Query Detects Dynamic Headers in SECONDS!

01:57

Simple Table Normalization - Power Query Challenge 34

02:26

TRANSLATE Function: Excel 365 Insider Tips

04:53

Transform Columns All at Once in Power Query: Ultimate Tutorial

02:37

Add Multiple Columns with One Easy Step! Power Query Hack

01:17

How to Calculate a Weighted Average in Excel

02:07

Merge Tables by Partial Value Matches - Power Query Challenge 33

02:48

Power Query Trick: Combine Inconsistent Files Like a Pro

04:09

Ultimate Guide to Excel Text Conversion: TEXT, VALUE, and More

04:19

Stop Using Generic Step Names! Power Query Tips for Clearer Code

05:13

List.TransformMany: Generating Combinations - Power Query Challenge 32

02:47

Excel Text Replacement: Master REPLACE & SUBSTITUTE

02:20

Create Fixed-Length IDs - Power Query Challenge 31

01:45

Order Status Transformation - Power Query Challenge 30

03:00

Calculate Year-To-Date in Excel: The Step-by-Step Guide

04:10

Transforming Messy Data - Power Query Challenge 29

02:50

Grouping Sales by 10-Day Intervals - Power Query Challenge 28