Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Formula Tricks and Techniques
Formula Tricks and
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
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)