Page 10 - Excel Workbook for Dummies

02_798452 ftoc.qxp 3/14/06 10:34 AM Page vii

Contents at a Glance

Introduction.................................................................................1

Part I: Creating Spreadsheets........................................................7
Chapter 1: Entering the Spreadsheet Data................................................................................................9
Chapter 2: Formatting the Spreadsheet ..................................................................................................23
Chapter 3: Printing Spreadsheet Reports ...............................................................................................37
Chapter 4: Modifying the Spreadsheet ....................................................................................................49
Part II: Using Formulas and Functions.........................................71

Chapter 5: Building Formulas ...................................................................................................................73
Chapter 6: Copying and Correcting Formulas ........................................................................................89
Chapter 7: Creating Date and Time Formulas.......................................................................................107
Chapter 8: Financial Formulas and Functions ......................................................................................115
Chapter 9: Using Math Functions...........................................................................................................125
Chapter 10: Using Statistical Functions.................................................................................................135
Chapter 11: Using the Lookup Functions ..............................................................................................141
Chapter 12: Using the Logical Functions...............................................................................................149
Chapter 13: Text Formulas and Functions ............................................................................................161

Part III: Working with Graphics ................................................169
Chapter 14: Charting Spreadsheet Data ................................................................................................171
Chapter 15: Adding Graphics to the Spreadsheet................................................................................185
Part IV: Managing and Securing Data........................................201

Chapter 16: Building and Maintaining Data Lists.................................................................................203
Chapter 17: Protecting the Spreadsheet ...............................................................................................221
Part V: Doing Data Analysis......................................................231

Chapter 18: Performing What-If Analysis ..............................................................................................233
Chapter 19: Generating Pivot Tables .....................................................................................................245
Part VI: Excel and the Web .......................................................259
Chapter 20: Publishing Spreadsheets as Web Pages ...........................................................................261
Chapter 21: Adding Hyperlinks to Spreadsheets .................................................................................273
Part VII: Macros and Visual Basic for Applications.....................283

Chapter 22: Using Macros .......................................................................................................................285
Chapter 23: Using the Visual Basic Editor.............................................................................................293
Part VIII: The Part of Tens ........................................................307

Chapter 24: Top Ten Tips for Using Excel like a Pro............................................................................309
Chapter 25: Ten (More or Less) Shortcut Keys for Entering Data .....................................................317
Chapter 26: Ten (More or Less) Shortcut Keys for Formatting the Worksheet ...............................319