Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables [With CDROM]

by Jinjer L. Simon

Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80-90% of the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate it to suit your needs, and achieve more by doing less work. Charts are interactive, allowing the...

• Format: Paperback
• Language: English
• ISBN: 0764597809
• ISBN13: 9780764597800
• Release Date: May 2005
• Publisher: Visual
• Length: 291 Pages
• Weight: 1.51 lbs.
• Dimensions: 0.8" x 8.1" x 9.1"

Customer Reviews

Blueprint for Excel Data Analysis Follows Through

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..

AWESOME

This is the best book I have found for excel. Quick, with just enough information to find almost anything to get you on the right track. Not for the beginner but more for the intermediate.

A good reference, but not for "anybody"; allow me to explain

First of all I have to confess that this book was acquired under the conditions that I probably know 90% of the materials covered in the book. Thus my interest is in the 10% I am not aware of and the other 10% if there are alternative ways to solve problems better than I am doing now.In this regards, I am satisfied. However if you are looking for learning simple "how-to"s like conditional formula, creating a chart, you would be disappointed since this book covers too much depth for beginners and it becomes easy to get lost in the sea of information.

Quick and Dirty- but Immensely Practical

The "Read Less - Learn More" trademark on the cover encapsulates the essence of what any reader can get out of this very non-traditional software user's guide.Although I am an MBA grad and am knowledgeable of data analysis techniques, I had always considered myself a novice user of Excel. I recently found myself in a predicament where I had to quickly learn the more complicated Excel features of data analysis in preparation for an interview for a position with a market research firm. In a panic, I went to the local B & N bookstore and bought a copy of the old stand-by Dummies Series- "Excel Data Analysis" (I'll refer to it as "DS"), as well as the book in this review (I'll refer to it as Visual Blueprint, "VB"). The thing about this book that really appealed to me was the logical and clean (uncluttered) explanation of each of the topics presented. It's a very user-friendly manual to follow along with the use of a computer (to go through the exercises).Progressive screen-shots are always located at the bottom half of each page, in successive order from left to right with clearly labeled numbered steps to follow. The examples that are shown in the screen shots are simple but very illustrative. On the top half of each left page is an introduction of the topic being covered and what the main processes are to accomplish the particular task. On the top half of each right page are additional methods of application and extra hints and descriptions of the syntaxes for functions that can be used. The arrangement of the graphics and the text work very well together and allow the reader to efficiently grasp each of the concepts being presented. What would normally be covered by a traditional user's manual in five to ten pages (reading from top to bottom- large text sections interspersed by graphics), this reference does the same in either two pages or four pages maximum. The way the editors have laid out this manual was very clever; not only does the reader have a lot less pages to get lost in (especially when trying to work through the examples with a computer) but also the topics are presented concisely and as simply as possible. I relied heavily on this book to prepare myself for an Excel test given by the company I was interviewing with. I spent at least 90% of my time referring to VB, and where necessary, I spent 10% of my time referring to DS for supplementary information. I studied over a period of one week and passed the test well enough to be hired!As enthusiastic as I am about this book, it is far from perfect with regards to being an ultimate and comprehensive manual for Excel. (That said, however, the Appendices are full of useful information...keystroke and navigation shortcuts as well as a handy reference for VBA and function syntaxes / commands....much more than is included in DS.) Additionally, as another reviewer had written previously, I can corroborate that I had found a few minor errors (formula calculations in examples, synta