Excel Fundamentals - Comprehensive Formula Lesson

) Introduction.
) Excel’s Golden Rule.
) Look at list of Formula Types and Formula Elements.
) Number Formula Examples.
) Text and Number Formulas for counting numbers above a hurdle.
) When to combine Comparative Operator and Number in a cell or when to combine Comparative Operator and Number in the formula..
) DOLLAR function..
) How to combine Comparative Operator and Number in the formula..
) VLOOKUP function and Array Constant.
) IF Function.
) Logical Formula.
) Aggregate Calculation / Aggregate Formula.
) Array Calculation / Array Formula.
) Excel Formula Order of Precedence (Excel’s Order of Operations).
) Tracking Down Errors in Excel: 4 Step Method..
) Types of Errors.
) When to use ROUND function.
) 3 ways to enter cell references into formulas.
) Summary.
) Homework.