Use Formulas in Excel – sums
An Excel tutorial by Peter Kalmstrom In the demo below Peter Kalmstrom goes through the basics of Excel formulas. The possibility to tell Excel to calculate is a crucial feature and the most important reason to use it, and here Peter explains how to tell the program what to count on = how to create a formula.
When you use a formula Excel calculates with the values of the cells you have given in thet formula and gives the result in a separate cell. When the values in the cells are changed the figure in the result cell will change automatically.
Excel is used for all kinds of calculations – from personal budgets to very advanced prognoses – but the calculations cannot be accurate if the formulas are not correct. (Refer to the kalmstrom.com blog for an example on what that might lead to.) With this demo Peter wants to set Excel new beginners on the right track.
Peter uses Excel 2013 for his demo, but the formulas are the same for earlier versions of Excel.
- What kind of information the cells in an Excel spreadsheet can contain and how you can see if Excel treats data as text or numbers.
- How you should NOT use Excel for calculations
- How to calculate a sum using a formula with the plus sign
- How to calculate a difference using a formula with the minus sign
- The functions of "sum", parenthesis and colon in formulas
- How to use the AutoSum button