Chapter 5. Calculating Data with Formulas and Functions
Formulas and functions are the real driving force of Excel's spreadsheet capabilities. In this chapter, you learn how to build formulas to perform calculations on your worksheet data, as well as tap into Excel's built-in functions.
Understanding Formulas
You can use formulas to perform all kinds of calculations on your Excel data. You can build formulas using mathematical operators, values, and cell references. For example, you can add the contents of a column of monthly sales figures to calculate a total number of sales. If you are new to writing formulas, this section explains all the basics ...
Get Teach Yourself VISUALLY™: Excel® 2007 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.
