Fix Excel Formula Errors Caused by Wrong Data Types (Text vs Numbers)
Ben Jones Explains
Fix Excel Formula Errors Caused by Wrong Data Types (Text vs Numbers)
15:25
Dynamic Column Referencing in Power Query | 3 Practical Methods
Ben Jones Explains
Dynamic Column Referencing in Power Query | 3 Practical Methods
16:19
Power Query: Combine Excel Files with Different Sheet Names (5 Dynamic Methods)
Ben Jones Explains
Power Query: Combine Excel Files with Different Sheet Names (5 Dynamic Methods)
15:33
Power Query: Combine Multiple Excel Files From Folder (Avoid Subfolder Issues)
Ben Jones Explains
Power Query: Combine Multiple Excel Files From Folder (Avoid Subfolder Issues)
9:15
Excel Regex Tutorial: Character Classes & Quantifiers Explained
Ben Jones Explains
Excel Regex Tutorial: Character Classes & Quantifiers Explained
21:44
How to Make PivotTables Auto Update in Excel (3 Easy Methods)
Ben Jones Explains
How to Make PivotTables Auto Update in Excel (3 Easy Methods)
19:50
Excel Power Query Dynamic Parameters | Bypass Firewall & Privacy Prompts with VBA
Ben Jones Explains
Excel Power Query Dynamic Parameters | Bypass Firewall & Privacy Prompts with VBA
14:50
How to Unpivot Data in Excel Using VBA Macro (Easy Guide)
Ben Jones Explains
How to Unpivot Data in Excel Using VBA Macro (Easy Guide)
17:56
Unpivot Data in Excel Using Python (Dynamic, Auto-Updating)
Ben Jones Explains
Unpivot Data in Excel Using Python (Dynamic, Auto-Updating)
10:06
Unpivot Data in Excel 365 Using Dynamic Array Formulas (No Power Query!)
Ben Jones Explains
Unpivot Data in Excel 365 Using Dynamic Array Formulas (No Power Query!)
13:05
Unpivot Data in Excel with Power Query (Step by Step Tutorial)
Ben Jones Explains
Unpivot Data in Excel with Power Query (Step by Step Tutorial)
13:28
Excel SUM Formula Showdown 🚀 SUMIFS, SUMPRODUCT, FILTER, MMULT Tested
Ben Jones Explains
Excel SUM Formula Showdown 🚀 SUMIFS, SUMPRODUCT, FILTER, MMULT Tested
16:44
Power Query Explained: Tables, Lists & Records (Finally Make M Code Click!)
Ben Jones Explains
Power Query Explained: Tables, Lists & Records (Finally Make M Code Click!)
16:10
Regex in Excel 365: Complete Guide to REGEXEXTRACT, REGEXTEST & REGEXREPLACE
Ben Jones Explains
Regex in Excel 365: Complete Guide to REGEXEXTRACT, REGEXTEST & REGEXREPLACE
16:10
Stop Using AND/OR in Excel! Use * and + Instead 🚀 (XLOOKUP, FILTER, INDEX MATCH)
Ben Jones Explains
Stop Using AND/OR in Excel! Use * and + Instead 🚀 (XLOOKUP, FILTER, INDEX MATCH)
14:25
How to Use Excel LAMBDA Functions in Any Workbook with VBA | Reuse Custom Formulas Everywhere
Ben Jones Explains
How to Use Excel LAMBDA Functions in Any Workbook with VBA | Reuse Custom Formulas Everywhere
15:33
Flat Table vs Star Schema vs Snowflake: Data Modeling for Power BI & Power Pivot
Ben Jones Explains
Flat Table vs Star Schema vs Snowflake: Data Modeling for Power BI & Power Pivot
12:45
Stop Using VLOOKUP! Master XLOOKUP in Excel 365 (Complete Tutorial + Advanced Tips)
Ben Jones Explains
Stop Using VLOOKUP! Master XLOOKUP in Excel 365 (Complete Tutorial + Advanced Tips)
16:02
Stop Repeating Tasks in Excel! Automate Everything with VBA (Beginner-Friendly Tutorial)
Ben Jones Explains
Stop Repeating Tasks in Excel! Automate Everything with VBA (Beginner-Friendly Tutorial)
20:50
Stop Using OFFSET! Excel’s New TRIMRANGE Function Explained (Faster Dynamic Ranges)
Ben Jones Explains
Stop Using OFFSET! Excel’s New TRIMRANGE Function Explained (Faster Dynamic Ranges)
10:35
ChatGPT vs Excel Expert: Testing AI on Formulas, Power Query & Python in Excel
Ben Jones Explains
ChatGPT vs Excel Expert: Testing AI on Formulas, Power Query & Python in Excel
16:49
STOP Using Static Formulas! Try Excel Dynamic Arrays Instead
Ben Jones Explains
STOP Using Static Formulas! Try Excel Dynamic Arrays Instead
22:32
Create Custom Excel Functions with LAMBDA (No VBA Needed!) 🔥 | Ultimate Excel LAMBDA Tutorial
Ben Jones Explains
Create Custom Excel Functions with LAMBDA (No VBA Needed!) 🔥 | Ultimate Excel LAMBDA Tutorial
10:27
Excel LET Function Tutorial | Clean, Fast & Smarter Formulas
Ben Jones Explains
Excel LET Function Tutorial | Clean, Fast & Smarter Formulas
8:32
How to Use Python in Excel | Full Tutorial + Real-World Examples
Ben Jones Explains
How to Use Python in Excel | Full Tutorial + Real-World Examples
13:41
Power Pivot in Excel: Full Beginner Tutorial (Data Model, Relationships, DAX + More!)
Ben Jones Explains
Power Pivot in Excel: Full Beginner Tutorial (Data Model, Relationships, DAX + More!)
18:23
Power Query for Beginners: Clean & Automate Excel Data Like a Pro!
Ben Jones Explains
Power Query for Beginners: Clean & Automate Excel Data Like a Pro!
15:21
Top 50 Excel Shortcuts You NEED to Know (No More Mouse!)
Ben Jones Explains
Top 50 Excel Shortcuts You NEED to Know (No More Mouse!)
9:39
The Complete Guide to Excel Tables for Beginners & Pros (Step-by-Step Tutorial)
Ben Jones Explains
The Complete Guide to Excel Tables for Beginners & Pros (Step-by-Step Tutorial)
13:25
How to Use Pivot Tables in Excel – Full Tutorial + Pro Tips (Calculated Fields & More!)
Ben Jones Explains
How to Use Pivot Tables in Excel – Full Tutorial + Pro Tips (Calculated Fields & More!)
15:13
Top Excel Time-Savers: Quick Access Toolbar & VBA Tips for Beginners
Ben Jones Explains
Top Excel Time-Savers: Quick Access Toolbar & VBA Tips for Beginners
14:31
Stop Using Developer Tab! Add Your Own Excel Ribbon for VBA Macros
Ben Jones Explains
Stop Using Developer Tab! Add Your Own Excel Ribbon for VBA Macros
14:37
Write Smarter Excel Formulas — Debug & Clean Up Like a Pro
Ben Jones Explains
Write Smarter Excel Formulas — Debug & Clean Up Like a Pro
11:23