F
ormulas and worksheet functions are essential to
manipulating data and obtaining useful information
from your Excel workbooks. The chapters in this
part present a wide variety of formula examples that use
many Excel functions. Two of the chapters are devoted to
array formulas. These chapters are intended primarily for
advanced users who need to perform calculations that may
otherwise be impossible.IN THIS PART
Chapter 10
Introducing Formulas and
FunctionsChapter 11
Creating Formulas That
Manipulate TextChapter 12
Working with Dates and TimesChapter 13
Creating Formulas That Count
and SumChapter 14
Creating Formulas That Look Up
ValuesChapter 15
Creating Formulas for Financial
ApplicationsChapter 16
Introducing Array FormulasChapter 17
Performing Magic with Array
FormulasPart II
Working with
Formulas and
Functions
14_474877-pp02.indd 19314_474877-pp02.indd 193 3/29/10 11:41 PM3/29/10 11:41 PM