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).
Was this article helpful?