Excel 2016 from Scratch
Introduction to Formulas
An Excel tutorial by Peter Kalmstrom
In this demo in the Excel 2016 from Scratch series, Peter Kalmstrom explains
the benefits of formulas.
Formulas are the very core of Excel, because calculating is something that
Excel is really good at. Also refer to a
kalmstrom.com Blog post about Excel calculation.
This is what Peter showns in the demo below:
Peter uses Excel 2016 for his demo, but the Excel basics are the same for
earlier versions of Excel.
- How to use the Excel Autosum button.
- How a calculated sum changes when you change a value in one of the included
cells – provided you use a formula for the calculation.
- How to manually create two kinds of formulas that both tell Excel to
calculate a sum.