Chapter 14. Using Formulas and Functions
In this chapter
Using Range Names and Labels in Formulas
Manipulating Data with Worksheet Functions
Putting Worksheet Functions to Use
Using Goal Seek to Find Values
Extra Credit: Nesting Functions Within Functions
Entering and Editing Formulas
Formulas add intelligence to a workbook. Using formulas, you can manipulate values (text, numbers, or dates), perform simple or complex calculations, and display alternative results based on logical tests.
With the help of formulas, you can perform any of the following common tasks:
- Manage home finances by tracking expenses
- Simplify coursework in advanced math and statistics classes
- Create “what-if” ...
Get Special Edition Using Microsoft® Office Home and Student 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.
