Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Getting More Out of Formulas
Getting More Out
Although Excel works well as both a simple
database and a data visualization tool, for
most people, Excel is all about calculations
in general, and formulas in particular.
Almost all spreadsheets include at least a
few formulas, and many models have
dozens of formulas.
and techniques you need to know about
to help you get more out of those formulas.
These include toggling between displaying
formulas and results; monitoring a formula
result with a Watch Window; creating array
formulas and links to other worksheets;
and troubleshooting formula errors.
Regardless of the size of your spreadsheet,
if it contains formulas, then there are tools