Excel 2007 Data Analysis For Dummies

Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentations
Now revised with over 30 percent new content to cover the enhancements in Excel 2007, including the completely redesigned user interface, augmented charting and PivotTable capabilities, improved security, and better data exchange through XML
Provides thorough coverage of Excel features that are critical to data analysis-working with external databases, creating PivotTables and PivotCharts, using Excel statistical and financial functions, sharing data, harnessing the Solver, taking advantage of the Small Business Finance Manager, and more

Customer Reviews:

Very good book on the subject, especially on Pivot Tables

By Gaetan Lion - June 23, 2009

I am a big fan of the Dummies books. I bought a ton of them and managed to learn a lot of good stuff this way. The author, Stephen Nelson, covers this occasionally not so simple subject in a very user friendly way right in line with the Dummies series tradition.

Keep in mind what this book' s purpose is about. It is essentially an Excel manual specializing on a specific set of functions to conduct certain types of data analysis. It is not a book about statistical analysis or data analysis. The author teaches you how to use those functions and Excel capabilities, but he won't teach you much about data analysis and statistics. For that you will need specific statistics books written by statistics professors. This book instead is a "how to" guide written by a CPA. And, given the book's purpose that's just fine.

Also, before buying any such book make sure you really study the table of content. This is to ensure the book covers what you need to learn... read more

Excel 2007 Data Analysis is Great

By Bubba T - March 19, 2007

I really like this book. It is written in very plain and easy to follow format. Anyone with any Excel knowledge at all will find it remedial at first however once you get to the part that interests you, it's great. It is easy to follow and informative. The author also uses humor to lighten it up, tech manuals can be very dry. This one is not.

I recomend the book for anyone just starting to do analysis with Excel. You will get your money's worth and will be able to finish the book without dying from bordom.

Data Analysis

By M.S. - August 17, 2009

Good book if you're not so great with building charts etc. in excel, funny too! Plus you get to find out where some of the stuff you're used to in excel '03 went to.