Part II
Working with Formulas and
Functions
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.IN THIS PART
Chapter 9
Introducing Formulas and Functions
Chapter 10
Using Formulas for Common Mathematical
Operations
Chapter 11
Using Formulas to Manipulate Text
Chapter 12
Using Formulas with Dates and Times
Chapter 13
Using Formulas for Conditional Analysis
Chapter 14
Using Formulas for Matching and Lookups
Chapter 15
Using Formulas for Financial Analysis
Chapter 16
Using Formulas for Statistical Analysis
Chapter 17
Using Formulas with Tables and Conditional
Formatting
Chapter 18
Understanding and Using Array Formulas
Chapter 19
Making Your Formulas Error-FreeExcel® 2019 Bible, First Edition. Michael Alexander, Dick Kusleika and John Walkenbach.
© 2019 John Wiley & Sons, Inc. Published 2019 by John Wiley & Sons, Inc.