BUILDING FORMULAS

Formula Fundamentals

Understanding the Precedence of Operators

Using Cell References

Editing Formulas

Using Functions: A Preview

Using AutoSum

Inserting Functions

Formula Bar Formatting

Creating Natural-Language Formulas

Naming Cells and Cell Ranges

Using Names in Formula

Defining and Managing Names

Editing Names

Naming Constants and Formulas

Pasting Names into Formulas

Creating a List of Names

Replacing References with Names

Understanding Error-Values

Worksheet Calculation

Recalculate Manually

Copying Formulas and pasting Only Their Values

Evaluating Part of a Formula

Using Circular References

Understanding the Precision of Numerical Values

Using Arrays

1-D Arrays

Array Formula Rules

2-D Arrays

Single-Cell Array Formulas

Using Array Constants

Understanding Array Expansion