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.
- Getting Familiar with the Excel 2010 Interface
- Entering the Spreadsheet Data
- Formatting the Spreadsheet
- Printing Spreadsheet Reports
- Modifying the Spreadsheet
- Building Formulas
- Copying and Correcting Formulas
- Creating Date and Time Formulas
- Financial Formulas and Functions
- Using Math Functions
- Using Common Statistical Functions
- Using Lookup Functions
- Using Logical Functions
- Text Formulas and Functions
- Charting Spreadsheet Data
- Adding Graphics to Spreadsheets
- Building and Maintaining Data Lists
- Protecting the Spreadsheet
- Performing What-If Analysis
- Generating Pivot Tables
- Using Macros
- Using the Visual Basic Editor
- Top Ten Features in Excel 2010
- 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
.

Copyright 2011 - VBA Consultants Ltd