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
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)
Search JabSto ::

Custom Search