8. Using Formulas

Image

Excel is great for simple data entry, but its real strength is its capability to perform calculations. After you design a sheet to perform calculations, you can easily change the data and watch Excel instantly recalculate. This chapter includes the following topics:

Entering a formula into a cell

Comparing absolute and relative referencing

Using array formulas

Converting formulas to values

Troubleshooting formulas

This chapter not only shows you how to enter a formula, but also teaches you fundamental basics, such as the difference between absolute and relative referencing, which is important when you want to copy a ...

Get My Excel 2016 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.