Microsoft Office Tutorials and References
In Depth Information
Figure 2-14: Excel can monitor your formulas for possible errors.
Figure 2-15: The Insert Function dialog box is the best way to insert a function into a formula.
Excel also lets you create your own worksheet functions by using VBA. For details
about this powerful feature, see Chapter 10.
A name is an identifier that enables you to refer to a cell, range, value, formula, or graphic object.
Formulas that use names are much easier to read than formulas that use cell references, and
creating formulas that use named references is much easier.