Excel 2016 from Scratch
The Benefits of using Formulas
An Excel tutorial by Peter Kalmstrom
This demo in the Excel 2016 from Scratch series, is a direct
continuation of the fourth demo. Here Peter Kalmstrom contiues
to explain the benefits of formulas.
In the demo below Peter shows why you should never hardcode
calculations in Excel. Instead you should use the cell names
in your formulas, so that the calculation is updated when
a cell value is changed.
Peter also shows
Peter uses Excel 2016 for his demo, but the Excel basics
are the same for earlier versions of Excel.
- How to expand the range of a calculation.
- How to delete cell information.