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...
Dave Bruns
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.
...
How to use the COUNT function
In this video we'll look at how to use the COUNT function to count cells that contain numeric data.
...
How to use the COUNTIF function
In this video we'll look at how to use the COUNTIF function to count cells that meet multiple criteria in a set of data.
...