Excel Functions

AVERAGEIF  

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)