Excel Functions
The AVERAGEIF function is used to calculate the average (mean) value of a range of numbers based on a condition. (2:26)
COUNTIF
The COUNTIF function is used to count values based on a condition. (01:34)
IF
The IF function is used to return a value based on a true/false condition. (1:59)
SUBTOTAL
The SUBTOTAL function is used to calculate subtotals and grandtotals. (2:50)
SUMIF
The SUMIF function can is to aggregate a range of numbers based on a condition. (2:07)
Summary Statistics
This video contains examples of the following summary statistics: Mean, Median, Mode, Standard Deviation, Maximum, Minimum, Range. (3:32)
VLOOKUP
The VLOOKUP function is used to lookup values in a range of cells and return a corresponding value. (3:08)
VLOOKUP Age Range
This video shows how to use VLOOKUP to ages to predefined ranges for reporting. (3:03)