Page 14 - Excel Workbook for Dummies

02_798452 ftoc.qxp 3/14/06 10:34 AM Page xi
Table of Contents xi
Chapter 8: Financial Formulas and Functions...............................................................115

Working with Financial Functions........................................................................................115
Using the Basic Investment Functions ................................................................................116
Figuring the Depreciation of an Asset .................................................................................121

Chapter 9: Using Math Functions.....................................................................................125
Rounding Off Values...............................................................................................................125
Finding Products, Powers, and Square Roots ....................................................................127
Doing Fancier Sums ...............................................................................................................129
Summing products, squares, and their differences .................................................128
Conditional totals.........................................................................................................131

Chapter 10: Using Statistical Functions .........................................................................135
Computing Averages..............................................................................................................135
Finding the Highest and Lowest Values...............................................................................136
Counting Cells.........................................................................................................................137
Using the Statistical Functions in the Analysis ToolPak Add-in.......................................139
Chapter 11: Using the Lookup Functions........................................................................141
Returning Single Values from a Lookup Table....................................................................141
Performing a horizontal lookup .................................................................................142
Performing a vertical lookup ......................................................................................144
Using the Lookup Wizard......................................................................................................146
Chapter 12: Using the Logical Functions........................................................................149
Working with the Logical Functions ....................................................................................149
Constructing Decision-Making Formulas ............................................................................150
Selecting between alternate values............................................................................150
Selecting between alternate calculations..................................................................153
Nesting IF functions .....................................................................................................155
Constructing Error-Trapping Formulas...............................................................................157
Chapter 13: Text Formulas and Functions ......................................................................161
Constructing Text Formulas .................................................................................................161
Using Text Functions .............................................................................................................164

Part III: Working with Graphics .................................................169

Chapter 14: Charting Spreadsheet Data .........................................................................171
Understanding Excel Charts.................................................................................................171
Creating Charts ......................................................................................................................176
Formatting Charts..................................................................................................................180
Editing Charts.........................................................................................................................182

Chapter 15: Adding Graphics to the Spreadsheet.........................................................185
Understanding Graphic Objects...........................................................................................185
Using the Drawing Toolbar ...................................................................................................189
Inserting clip art...........................................................................................................189
Importing graphics files...............................................................................................192
Drawing and adding graphic shapes..........................................................................194
Adding text boxes.........................................................................................................196
Constructing WordArt..................................................................................................198