Excel Off The Grid will show you how to work smarter, not harder with Microsoft Excel.

Visit my website: https://exceloffthegrid.com

Unpivot with Formulas in Excel... No Power Query!!
13:47
Unpivot with Formulas in Excel... No Power Query!!
Automate Power Query with VBA - Taking Power Query to the Next Level
11:02
Automate Power Query with VBA - Taking Power Query to the Next Level
The FASTEST Way to Unstack Data in Power Query? 3 Methods Compared
11:54
The FASTEST Way to Unstack Data in Power Query? 3 Methods Compared
Custom Sorting with Excel formulas - Taking SORTBY to the next level!
6:25
Custom Sorting with Excel formulas - Taking SORTBY to the next level!
Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query
13:02
Combine Multiple Excel Sheets with a Transform Sample Sheet in Power Query
Stop Excel calculating blank cells as zero
6:54
Stop Excel calculating blank cells as zero
Dynamically insert blank rows between items in Excel | Make your analysis easier to read.
7:31
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!
9:38
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
9:54
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.
11:14
GROUPBY in Excel with dynamic drill down... Yes, it's possible.
GROUPBY with Multiple Tables in Excel – The Ultimate Guide!
9:45
GROUPBY with Multiple Tables in Excel – The Ultimate Guide!
Budget vs Actual with GROUPBY & PIVOTBY - SUPERCHARGE your reporting!
9:46
Budget vs Actual with GROUPBY & PIVOTBY - SUPERCHARGE your reporting!
Using Flexible Functions in Excel (only for advanced users).
9:13
Using Flexible Functions in Excel (only for advanced users).
The BEST Way to Calculate Moving Averages in Excel with Dynamic Arrays
9:31
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!
6:22
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
8:51
Excel Conditional Formatting Formulas - Format Like a Pro
Complete report in Excel with just ONE formula!
13:13
Complete report in Excel with just ONE formula!
Dynamic array total rows that move automatically? Watch this!
12:31
Dynamic array total rows that move automatically? Watch this!
The TRUTH about Filter - Advanced filter techniques in Excel and Power Query
14:50
The TRUTH about Filter - Advanced filter techniques in Excel and Power Query
Excel Multiple Column Lookups: Which Method is Best?
15:41
Excel Multiple Column Lookups: Which Method is Best?
Stop manual work in Excel with this blueprint.
11:13
Stop manual work in Excel with this blueprint.
Supercharge Excel: Build Your Custom Function Library in Minutes!
7:37
Supercharge Excel: Build Your Custom Function Library in Minutes!
DOUBLEXLOOKUP... the Excel function you've been waiting for!
12:29
DOUBLEXLOOKUP... the Excel function you've been waiting for!
Even easier than easiest - Multi Level Dependent Drop Down Lists
7:35
Even easier than easiest - Multi Level Dependent Drop Down Lists
Excel's dirty little secrets - 5 things it does you don't expect!
11:25
Excel's dirty little secrets - 5 things it does you don't expect!
Better than XLOOKUP? Try SUPERXLOOKUP!
11:39
Better than XLOOKUP? Try SUPERXLOOKUP!
Slicer Sorting Simplified: The quick and effective way that actually works!
10:08
Slicer Sorting Simplified: The quick and effective way that actually works!
XLOOKUP Spilling Secret: How to fix the array of arrays problem!
5:58
XLOOKUP Spilling Secret: How to fix the array of arrays problem!
Easiest Multi-Level Drop-Down Lists in Excel!
8:27
Easiest Multi-Level Drop-Down Lists in Excel!
Ultimate XLOOKUP Guide: 10 Tips You Need to Know!
13:14
Ultimate XLOOKUP Guide: 10 Tips You Need to Know!