Thank you for visiting us. We are currently updating our shopping cart and regret to advise that it will be unavailable until September 1, 2014. We apologise for any inconvenience and look forward to serving you again.

Dummies.com
  • Print
  • Share
Excel Workbook For Dummies (0470044101) cover image

Excel Workbook For Dummies

ISBN: 978-0-470-04410-0
E-book
368 pages
August 2006
US $16.99 Purchase This E-book

This price is valid for United States. Change location to view local pricing and availability.

How to read this e-book on:
Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your e-book.
Introduction.

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.

  • Print
  • Share