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).



0 0

Post a comment