Download Start Excel File: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/01IntroductionToExcel/ExcelBusinessMathVideo06-FormulaElementsTips.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/Content/01IntroductionToExcel/ExcelBusinessMathVideo06-FormulaElementsTips.pdf
Entire Class Web Site: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm
In this video learn all about Excel Formulas. 20 amazing examples that show all the different types of formulas and the different formula elements that go into formulas. Also get a Formula Check List Sheet that showcases all the types you need to create efficient formula every time : )
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:49) Math Order of Operations and First Five Formula Examples
3. (06:350 See how to use Evaluate Formula feature in Excel to step through and see how Excel calculates your formula, step by step.
4. (11:03) Comparative Operators and Two Examples of Logical Formulas
5. (17:52) Different Phrases for Comparative Operators; A Complete List to help you figure out what Comparative Operator to use in your formula.
6. (21:18) Look at Formula Check List Sheet that has a checklist of tips for creating Efficient Formulas.
7. (23:03) 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
8. (38:16) Learn when to use Double Click to Copy a Formula Down a Column and when to manually copy the formula down
9. (39:56) Two Important tips about SUM Function. Tip 1: Don’t use Plus Symbol. Tip 2: Don’t wrap SUM Function around math calculation.
10. (43:16) 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
11. (45:44) Summary
Next Video: Excel & Business Math 07