Dave Bruns

In this video, we'll look at how boolean operations are used in array formulas. This is a key concept in developing more advanced dynamic array formulas...

When working with more advanced formulas, especially array formulas, you need to know how to convert TRUE and FALSE values in Excel to their numeric equivalents, 1 and 0. In this video, we'll look at some ways you can convert TRUE and FALSE values in Excel to 1s and 0s...

The term "array" comes from programming, but you'll hear it often in the context of more advanced Excel formulas. In this video, we'll answer the question "what is an array?" ...

In this video, we'll set up XLOOKUP to return multiple values in a dynamic array, by providing a range of lookup values instead of a single lookup value...

In this video, we’ll set up the XLOOKUP function to perform an approximate match in order to calculate a quantity based discount.

In this video, we'll look at how to nest dynamic array functions together to create powerful and dynamic solutions...

In this video we'll look at how dynamic array behavior is native and deeply integrated in Excel. Even older functions can use this new feature...

In this video, we’ll look at a core concept in dynamic array behavior - spilling and the spill range.

With the introduction of dynamic array formulas, Excel includes 6 brand new functions that directly leverage dynamic array behavior. In this video, we quickly demo all 6.