How to use the COUNTIFS function
In this video we'll look at how to use the COUNTIFS function to count cells that meet multiple criteria in a set of data.
...
Dave Bruns
How to use the SUM function
In this video we'll look at some tips and tricks for using the SUM function; one of the most widely used functions in Excel...
How to use the SUMIF function
In this video we'll look at how to use the SUMIF function to sum cells that meet a single criteria in a set of data.
...
How to use the SUMIFS function
In this video, we'll look at how to use the SUMIFS function to sum cells that meet multiple criteria in a set of data.
...
How to create a dynamic named range with INDEX
In this video we'll look at how to create a dynamic named range with the INDEX function. INDEX is a non-volatile function, so it won't recalculate whenever a change is made to a worksheet...
How to create a dynamic named range with OFFSET
In this video we'll look at how to create a dynamic named range using the OFFSET function; the most common way to create a dynamic named range with a formula...
What is a dynamic named range
In this video we'll introduce the idea of a dynamic range and show you why you might want to use one. Spoiler: they adjust formulas automatically when data changes...
How to create a dynamic named range with a Table
In this video we'll look at how to create a dynamic named range with a Table. This is the simplest way to create a dynamic named range in Excel...
How to use HLOOKUP
In this video we'll look at how to use the HLOOKUP function. HLOOKUP works like VLOOKUP but is meant for data in a horizontal arrangement...
How to do a two-way lookup with INDEX and MATCH
In this video we'll use MATCH to find the position of an item in a table and the INDEX function to retrieve the value at that position in a two-way lookup...