Use Formulas in Excel – sums
An Excel tutorial by Peter Kalmstrom
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
- How to calculate a difference using a formula with
the minus sign
- The functions of "sum", parenthesis and colon in
How to use the AutoSum button