Part 4: Formulas and Functions

Perhaps the most valuable feature of Excel is its ability to produce mathematical outputs using the data in a workbook. This section reviews several mathematical outputs that you can produce in Excel through the construction of formulas and functions. The section begins with a chapter on the construction of formulas for basic and complex mathematical computations. Another chapter reviews statistical functions, such as SUM, AVERAGE, MIN, and MAX, which can be applied to a range of cells. Another chapter addresses functions used to calculate mortgage and lease payments as well as the valuation of investments. This section also shows how you can use data from multiple worksheets to construct formulas and functions.