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.