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
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.