Page 16 - Excel Workbook for Dummies

02_798452 ftoc.qxp 3/14/06 10:34 AM Page xiii
Table of Contents xiii
Chapter 21: Adding Hyperlinks to Spreadsheets..........................................................273

Creating Hyperlinks ...............................................................................................................273
Adding links to other sheets in a workbook.............................................................274
Adding links to other documents...............................................................................275
Adding links to Web pages ..........................................................................................277
Editing Hyperlinks..................................................................................................................279
Assigning Links to Toolbars and Menus .............................................................................279

Part VII: Macros and Visual Basic for Applications......................283

Chapter 22: Using Macros.................................................................................................285
Creating Macros .....................................................................................................................285
Using the macro recorder ...........................................................................................285
Recording macros with relative cell references .......................................................288
Assigning Macros to Toolbars and Menus..........................................................................290
Chapter 23: Using the Visual Basic Editor .....................................................................293
Using the Visual Basic Editor ...............................................................................................293
Editing a recorded macro............................................................................................295
Adding a dialog box that processes user input........................................................297
Creating User-Defined Functions .........................................................................................300
Using a custom function in your spreadsheet..........................................................302
Saving custom functions in add-in files.....................................................................303

Part VIII: The Part of Tens .........................................................307

Chapter 24: Top Ten Tips for Using Excel like a Pro.....................................................309

Generate New Workbooks from Templates ........................................................................309
Organize Spreadsheet Data on Different Worksheets........................................................310
Create Data Series with AutoFill...........................................................................................310
Use Range Names...................................................................................................................311
Freeze Column and Row Headings.......................................................................................312
Prevent Data Entry Errors with Data Validation ................................................................312
Trap Error Values in Their Original Formulas....................................................................313
Save Memory by Using Array Formulas..............................................................................313
Controlling the Display of Data in Tables through Outlines.............................................314
Use Compare Side by Side to Work with Two Workbooks................................................314
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

Chapter 27: Ten (More or Less) Shortcut Keys for Editing Data .................................321

Chapter 28: Ten (More or Less) Miscellaneous Shortcut Keys ..................................323

Appendix A: About the CD .........................................................325

Appendix B: Table of Exercises ...................................................329

Index .......................................................................................337