IN THIS CHAPTER
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?