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.
Note | For a much more comprehensive treatment of Excel formulas and functions, refer to my book, Excel 2007 Formulas (Wiley). |