06:11

The AND Function in Excel is Broken – Here's How to Fix It!

08:57

STOP using nested IF statements! Use these functions instead.

06:36

Power Query Secrets: Use coalesce (??) to handle null values

07:27

10 Power Query tips EVERY user should know! | Excel Off The Grid

10:37

Static to dynamic: Excel formulas for reducing manual work

11:52

Financial Reporting from Trial Balances - Super fast

07:14

Power Query Vs VSTACK: Combine Tables in an Excel workbook | Excel Off the Grid

12:36

Advanced Excel Functions | BYROW vs MAP vs SCAN vs REDUCE | Excel Off The Grid

05:41

Start Excel the fast way: Open with a template | Excel Off The Grid

10:53

Easy way to unlock Excel & VBA without a password

08:07

Using dynamic arrays in a Table : 4 methods | Excel Off The Grid

11:50

Change category while keeping history | Slowing changing dimensions with Excel and Power Query.

10:57

Power Query made easy - learn the power of Quick Steps | Excel Off The Grid

10:15

Awesome IMAGE function techniques you need to know! | Excel Off The Grid

08:37

Power Query Calendar Table - including Financial & Non-Standard Calendars

11:20

The #1 Excel formula issue - Data structure | Excel Off The Grid

13:23

Next level FILTER Function tricks | Excel Off The Grid

15:44

10 awesome Power Query tricks you NEED to know! | Excel Off The Grid

08:17

Formatted dynamic chart titles in Excel | Achieve the IMPOSSIBLE | Excel Off The Grid

06:25

Convert Text to a Formula in Excel | The CRAZY method for tough Excel problems.

05:10

Create data validation list from Excel Table... the RIGHT WAY!

08:44

How to change the source data connector in Power Query | Excel Off The Grid

10:25

Create your own keyboard shortcuts in Excel | Excel Off The Grid

06:40

Create multiple folders at once with Excel (the easy way!) | Excel Off The Grid

13:54

How to automate Excel with reusable Office Scripts | Excel Off The Grid

12:38

Don't trust data validation in Excel! | Excel Off The Grid

06:30

Change number format based on cell value | Excel Off The Grid

18:28

Jitter plot in Excel | 100% dynamic | Excel Off The Grid

10:41

Table slicers for advanced interactivity in Excel | Excel Off The Grid

08:07

Use slicers with PIVOTBY, GROUPBY & FILTER in Excel | Excel Off The Grid

12:21

EOMONTH Function in Excel: How to + 8 Examples | Excel Off The Grid

14:59

How to make a Dumbbell Dot Plot in Excel (100% dynamic) | Excel Off The Grid

13:22

Using SUMIFS with arrays | Excel problem... Solved! | Excel Off The Grid

06:02

Calculate quarter from dates in Excel | Calendar Year, Financial Year, Non-Standard Calendars

07:34

Promote headers in nested tables before expanding columns | Power Query | Excel Off The Grid

06:26

How to Spill multiple FILTER functions in Excel | Excel Off The Grid

09:46

Add manual information into a query | Power Query | Excel Off The Grid

09:37

Automate reconciliations with Power Query | Excel Off The Grid

04:40

Get data from the latest file in a folder with Power Query | Excel Off The Grid

12:25

How to create chart data from Power Query | Excel Off The Grid

03:14

How to easily swap ranges in Excel (1 click) | Excel Off The Grid

05:23

Excel's secret data cache for external workbook links | Excel Off The Grid

08:19

3 Scenarios where you SHOULD merge Cells in Excel | Excel Off The Grid

16:28

Cross filter visuals in Excel | Amazing interactive charts | Excel Off The Grid

11:01

Replace column names of nested tables using Power Query | Excel Off The Grid

11:40

How to create Multiple PDFs from Excel (Office Scripts + Power Automate) | Excel Off The Grid

06:38

Add a Fiscal Month, Quarter or Year Column in Power Query | Excel Off The Grid

07:41

Power Query: How to mass replace values based on a list | Excel Off The Grid

08:14

Transform nested tables in Power Query (without writing M coding) | Excel Off The Grid

06:45

Find & Replace multiple words in Excel | REDUCE & SUBSTITUTE | Excel Off The Grid

06:10

Create Shareable, Interactive, View Only Dashboards from Excel | Excel Off The Grid

05:50

Power Query: Connect to Files in a List | Excel Off The Grid

01:59

Office Scripts: Automate Excel Everywhere | Excel Off The Grid

12:48

Dynamic Text in Excel | TEXT function + Number Formats | Excel Off The Grid

09:57

Excel Waffle Charts that work everywhere (including Excel Online) | Excel Off The Grid

06:38

Make Waffle Charts in Excel... the EASY way | Excel Off The Grid

05:46

How to FIlter by a List in Excel | Excel Off The Grid

13:45

Excel number formats for accounting & finance you NEED to know | Excel Off The Grid

12:45

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

09:04

Run macros from Power Automate Desktop | Excel Off The Grid