|
Featured Tutorial
Featured Macro
Highline Excel Class 30: SUMIF, RANK & Bonuses
Topics for this video:
1)SUMIF function to add with one criteria
2)RANK function to rank the highest to lowest (one to five)
3)IF function to assign a bonus
4)Boolean Logic TRUE FALSE formula to assign a bonus
5)Formula Evaluator for Boolean Logic Formula
6)See how to use Excel Table Formula Nomenclature in formulas
7)Custom Number formatting for Formula Inputs
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
1)SUMIF function to add with one criteria
2)RANK function to rank the highest to lowest (one to five)
3)IF function to assign a bonus
4)Boolean Logic TRUE FALSE formula to assign a bonus
5)Formula Evaluator for Boolean Logic Formula
6)See how to use Excel Table Formula Nomenclature in formulas
7)Custom Number formatting for Formula Inputs
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109