Excel Modeling Teaching

Excel Formulas Useful for Production, Operations, and Manufacturing Management

These are useful Excel formulas for your operations management, quality management courses etc..

This is a continuously updated list. For the most recent update, please visit my website here.

FormulaTagsBrief DescriptionExample Video or Manual
AVERAGE(range)StatisticsCount the average of the range
COUNT(range)StatisticsCount number of numeric values within the range
EXPON.DIST(x, lambda, TRUE)StatisticsProbability that a unit will fail within x hour given the hourly failure rate is lambda
NORM.DIST(x, average, sd, true)StatisticsProbability that is smaller than the provided x given the average and the s.d.
NORM.INV(p, average, sd)StatisticsSeeks that value x such that NORM.DIST(x, mean, standard_dev, TRUE) = probability
RAND()StatisticsGenerate random number between 0 and 1. Follows uniform distribution.
RANDBETWEEN(min, max)StatisticsGenerate random number between the value of the min and the max. Follows uniform distribution.
STDEV.S(range)StatisticsCount the standard deviation of the range. It considers the range as a sample
AND(cond1, cond2)LogicalTesting two more conditions, return TRUE when all conditions are true.
IF(condition, value_if_true, value_if_false)LogicalConditional statement.
OR(cond1, cond2)LogicalTesting two more conditions, return TRUE as long as one condition is true.
SUMPRODUCT(range1, range2)MathHandy in calculating weighted average
COMBIN(number, sample_size)MathNumber of different ways to choose sample_size from number. For example, 3 choose 2 = 3, there are three different ways of choosing 2 combination out of 3.

Leave a Reply