Part IIWorking 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

  1. Chapter 10Introducing Formulas and Functions
  2. Chapter 11Creating Formulas That Manipulate Text
  3. Chapter 12Working with Dates and Times
  4. Chapter 13Creating Formulas That Count and Sum
  5. Chapter 14Creating Formulas That Look Up Values
  6. Chapter 15Creating Formulas for Financial Applications
  7. Chapter 16Miscellaneous Calculations
  8. Chapter 17Introducing Array Formulas
  9. Chapter 18Performing Magic with Array Formulas

Get Excel 2016 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial