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