IN THIS PART
Introducing Formulas and Functions
Creating Formulas That Manipulate Text
Working with Dates and Times
Creating Formulas That Count and Sum
Creating Formulas That Look Up Values
Creating Formulas for Financial Applications
Introducing Array Formulas
Performing Magic with Array Formulas
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.