Excel Workbook For Dummies

Part I: Creating Spreadsheets.

Chapter 1: Entering the Spreadsheet Data.

Chapter 2: Formatting the Spreadsheet.

Chapter 3: Printing Spreadsheet Reports.

Chapter 4: Modifying the Spreadsheet.

Part II: Using Formulas and Functions.

Chapter 5: Building Formulas.

Chapter 6: Copying and Correcting Formulas.

Chapter 7: Creating Date and Time Formulas.

Chapter 8: Financial Formulas and Functions.

Chapter 9: Using Math Functions.

Chapter 10: Using Statistical Functions.

Chapter 11: Using the Lookup Functions.

Chapter 12: Using the Logical Functions.

Chapter 13: Text Formulas and Functions.

Part III: Working with Graphics.

Chapter 14: Charting Spreadsheet Data.

Chapter 15: Adding Graphics to the Spreadsheet.

Part IV: Managing and Securing Data.

Chapter 16: Building and Maintaining Data Lists.

Chapter 17: Protecting the Spreadsheet.

Part V: Doing Data Analysis.

Chapter 18: Performing What-If Analysis.

Chapter 19: Generating Pivot Tables.

Part VI: Excel and the Web.

Chapter 20: Publishing Spreadsheets as Web Pages.

Chapter 21: Adding Hyperlinks to Spreadsheets.

Part VII: Macros and Visual Basic for Applications.

Chapter 22: Using Macros.

Chapter 23: Using the Visual Basic Editor.

Part VIII: The Part of Tens.

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

Chapter 25: Ten (More or Less) Shortcut Keys for Entering Data.

Chapter 26: Ten (More or Less) Shortcut Keys for Formatting the Worksheet.

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

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

Appendix A: About the CD.

Appendix B: Table of Exercises.

Index.