Dive into a comprehensive 47-minute video tutorial exploring Excel formulas with 17 practical examples for business math applications. Master the math order of operations, use the Evaluate Formula feature, understand comparative operators, and learn efficient formula creation techniques. Explore a Formula Check List for creating effective formulas, discover when to use the ROUND function, and gain insights on copying formulas down columns. Acquire essential tips for using the SUM function correctly and learn how to interpret Excel's status bar modes. Download accompanying materials to enhance your learning experience and follow along with the instructor's step-by-step guidance through various formula types and elements crucial for business math calculations.
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
