Part II: Working with Formulas and Functions

Formulas 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

Miscellaneous Calculations

Chapter 17

Introducing Array Formulas

Chapter 18

Performing Magic with Array Formulas