Basic Formulas - Excel 2013 Tutorial

Basic Formulas - Excel 2013 Tutorial

• 1.
  PIVOT TABLE PRO LESSON:BASIC FORMULAS LEVEL: BEGINNER CONTENTS: 6 Basic Formulas 16 The Order of Operations PIVOT TABLE PRO Find more at WWW.PIVOTTABLE-PRO.COM
• 2.
  Using formulas iswhen beginning users often start to understand Excel’s usefulness, power and efficiency.
• 3.
  The five operatorsin this presentation, used with Excel’s formula syntax, will help accomplish many common tasks.
• 4.
  This presentation showsyou how to enter and edit basic formulas in Excel using values, cell references and/or other formulas as inputs.
• 5.
  By the endof this presentation you can:  calculate in a cell using mathematical operators  use values, cells and other formulas as formula inputs  change the order of operations with parentheses
• 6.
  Let’s add upthe two numbers here in the second row.
• 7.
  Formulas start withan equals (=) sign. This tells Excel to treat what you type next as a formula, rather than values or text.
• 8.
  When you completethe entry, Excel displays the answer in the cell. The formula bar shows the underlying calculation.
• 9.
  (If you leaveout the equals sign, Excel just treats the entry as text and doesn’t calculate it.)
• 10.
  What if youwant to calculate using the values in other cells?
• 11.
  To refer toother cells’ values, type their addresses into the formula. You can also do this by clicking on the cells, or using arrow keys.
• 12.
  The calculation updatesautomatically when the input cells change:
• 13.
  The other basicoperators in Excel are minus (-), multiply (*), Divide (/) and exponent (^).
• 14.
  Of course, youcan extend a formula by adding additional inputs:
• 15.
  You can usecombinations of values, cell references and other formulas/functions as arguments for your calculation.
• 16.
  The Order ofOperations  Like maths, where there is more than one operation, Excel calculates using the natural order of arithmetic operations – BODMAS.  Operations are calculated in the below order:  Brackets first, then:  Orders (ie powers & roots)  Division & Multiplication (going right-to-left)  Addition & Subtraction (going left-to-right)
• 17.
  The example demonstratesthe order of operations: 2^2*3+5 = 4*3+5 = 12+5 = 17
• 18.
  Enter parentheses () to manually change the order of operations. i.e. 2^2*(3+5) = 2^2*8 = 4*8 = 32
• 19.
  You can entermultiple sets of parentheses for more changes: i.e. 2^(2*(3+5)) = 2^(2*8) = 2^16 = 65536
• 20.
  PivotExcel is anindependent training program and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. Microsoft, Excel, and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Excel visuals used with permission from Microsoft. VISIT WWW.PIVOTTABLE-PRO.COM FOR MORE, INCLUDING A FREE TRIAL! See more at PIVOT TABLE PRO WWW.PIVOTTABLE-PRO.COM