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
Functions
Chapter 11
Creating Formulas That
Manipulate Text
Chapter 12
Working with Dates and Times
Chapter 13
Creating Formulas That Count
and Sum
Chapter 14
Creating Formulas That Look Up
Values
Chapter 15
Creating Formulas for Financial
Applications
Chapter 16
Introducing Array Formulas
Chapter 17
Performing Magic with Array
Formulas
Part 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