Microsoft Office Tutorials and References

In Depth Information

**Chapter 3: Formula Tricks and Techniques**

3

Formula Tricks and

Techniques

In This Chapter

●
Getting 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

About Formulas

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

book,
Excel 2010 Formulas
(Wiley).

Formulas, of course, are what make a spreadsheet a spreadsheet. If it weren’t for formulas, your

worksheet would just be a static document — something that a word processor that has great

support for tables could produce.

A formula entered into a cell can consist of any of the following elements:

h
Operators such as + (for addition) and * (for multiplication)

h
Cell references (including named cells and ranges)