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