Don't hard code values that may change
In this video we'll take a look at a few reasons why you shouldn't hard code values into your formulas that may change...
Dave Bruns
How to fill in missing data with a simple formula
In this video we'll look at a way to quickly add missing data to a worksheet. It's a simple technique using a very basic formula and a cool example of relative cell references...
How to fill in missing data part 2
In this video, we'll look at a way to fill in missing data using a formula created with the IF and ISBLANK functions...
The IF function
In this video we'll look at how to use the IF function, one of the most powerful and popular functions in Excel...
If this OR that
In this video we look at how to combine the IF function with the OR and AND functions to test more than one condition at the same time.
How to create a formula with nested IFs
In this video I'll show you how to create a formula that uses multiple, nested IF statements. This is a common technique to handle multiple conditions in a single formula...
How to calculate an average value
In this video we'll look at how to calculate an average from a set of data manually and with the AVERAGE function.
...
How to calculate maximum and minimum values
In this video we'll look at how to calculate minimum and maximum values in Excel using the MAX and MIN function.
...
How to use the AVERAGEIF function
In this video, we'll look at how to use the AVERAGEIF function to calculate an average from numbers that meet a single criteria in a set of data.
...
How to use the AVERAGEIFS function
In this video we'll look at how to use the AVERAGEIFS function to calculate an average from numbers that meet multiple criteria in a set of data.
...