Chapter 3: Formula Tricks and Techniques


image from book  Download CD Content

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




Excel 2007 Power Programming with VBA
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net