Book Review: Excel 2010 Workbook For Dummies

by VBA Consultants Ltd 5. February 2011 08:15

Title: Excel 2010 Workbook For Dummies
Author: Greg Harvey
Publisher: Wiley
ISBN: 9780470489604

The title of this book gives you an indication that this is not the typical Dummies book. This book is setup like a workbook in grade school. It contains detailed step-by-step instructions on how to accomplish specific tasks in Microsoft Excel using practical exercises. In addition to the instructions, the accompanying CD contains completed worksheets for the exercises, allowing you to check your results. The exercises are organized into the following 24 chapters.

  1. Getting Familiar with the Excel 2010 Interface
  2. Entering the Spreadsheet Data
  3. Formatting the Spreadsheet
  4. Printing Spreadsheet Reports
  5. Modifying the Spreadsheet
  6. Building Formulas
  7. Copying and Correcting Formulas
  8. Creating Date and Time Formulas
  9. Financial Formulas and Functions
  10. Using Math Functions
  11. Using Common Statistical Functions
  12. Using Lookup Functions
  13. Using Logical Functions
  14. Text Formulas and Functions
  15. Charting Spreadsheet Data
  16. Adding Graphics to Spreadsheets
  17. Building and Maintaining Data Lists
  18. Protecting the Spreadsheet
  19. Performing What-If Analysis
  20. Generating Pivot Tables
  21. Using Macros
  22. Using the Visual Basic Editor
  23. Top Ten Features in Excel 2010
  24. Top Ten Tips for Using Excel Like a Pro

Although the author assumes that the reader is a new user of Excel 2010, you can tell from the list of chapters that some of the topics are beyond what is normally covered in a beginning book. Also, this book has almost no screen shots. It assumes that you are reading the book while at your computer with Excel open. If you need pictures to learn, you should check out the Visual series.

You may purchase Excel 2010 Workbook For Dummies from Amazon.

View VBA Consultants' profile on LinkedIn

Copyright 2011 - VBA Consultants Ltd

Tags:

Book Review