Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
Overview
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). |