Overview
Syllabus
) Introduction.
) Math Order of Operations and First Five Formula Examples.
0 See how to use Evaluate Formula feature in Excel to step through and see how Excel calculates your formula, step by step..
) Comparative Operators and Two Examples of Logical Formulas.
) Different Phrases for Comparative Operators; A Complete List to help you figure out what Comparative Operator to use in your formula..
) Look at Formula Check List Sheet that has a checklist of tips for creating Efficient Formulas..
) 10 Formula Examples that illustrate all the different types of formulas and the different formula elements that go into formulas for this Business Math Class. Review of Excel’s Golden Rule, Review of When you MUST use ROUND Function.
) Learn when to use Double Click to Copy a Formula Down a Column and when to manually copy the formula down.
) Two Important tips about SUM Function. Tip 1: Don’t use Plus Symbol. Tip 2: Don’t wrap SUM Function around math calculation..
) Important Tip about how to use F2 Key if Arrow Keys will not put Cell References in Formulas. And learn how to read Status Bar when you are creating a formula to correctly interpret the mode when it is; 1) Ready, 2) Enter, 3) Point or 4) Edit.
) Summary.
Taught by
ExcelIsFun