In regard to content and functionality, Jinjer Simon’s book is a more than adequate text that takes the reader from the rudimentary to the intermediate/advanced techniques in each of the areas of Excel data analysis that is covered.
For the most part, the format is concise and clear.
The association between text and spreadsheet illustrations is well done.
Appendixes A and B in the back are helpful in quick referencing: Excel functions (B) and VBA statements, VBA functions, and Excel Events.
The CD does an adequate job of providing some but not all the examples that I would have liked to see.
I do appreciate the data analysis software trial tools offered on the CD.
Its always nice to be able to kick the tires before purchasing or recommending additional software.
In regard to real world application, I have found Chapters 5: Working with External Data , and Chapter 11: Using the Analysis Tool Packs Add-ins as a good reference guide to small business auditing in Excel.
The definitions, concepts and instructions are easy to communicate to the small business user and staff.
Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables
Title: Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables
Author(s): Jinjer Simon