Formula Tricks and Techniques


This chapter provides an overview of Excel's formula-related features and describes some techniques that might be new to you.

♦ An overview of Excel formulas

♦ Differentiating between absolute and relative references in formulas

♦ Understanding and using names

♦ Introducing array formulas

♦ Counting and summing cells

♦ Working with dates and times

♦ Creating megaformulas

Virtually every successful spreadsheet application uses formulas. In fact, constructing formulas can certainly be construed as a type of programming.

For a much more comprehensive treatment of Excel formulas and functions, refer to my Excel2003 Formulas book.

Was this article helpful?

0 0

Post a comment