Excel 2007 Data Analysis For Dummies [Paperback]

Stephen L. Nelson (Author)

Book Description

Publication Date: February 20, 2007 | ISBN-10: 047004599X | ISBN-13: 978-0470045992 | Edition: 1

• 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

Editorial Reviews

From the Back Cover

Unleash the power of Excel to make sense of your data

The fun and easy way to gain new insights into your data

This handy guide helps you analyze the information you work with in your job to make better decisions. From grabbing external data to working with PivotCharts, database functions, and regression analysis, it shows you step by step how Excel can turn raw data into intelligible information.

Discover how to

• Import data into Excel
• Work with PivotTables
• Use database and statistical functions
• Customize PivotCharts
• Set up a Solver worksheet
• Perform regression analysis calculations

About the Author

Stephen L. Nelson, MBA, CPA, provides accounting, business advisory, tax planning, and tax preparation services to small businesses. He belongs to the American Institute of CPAs and is a prolific author.

Product Details

• Paperback: 384 pages
• Publisher: For Dummies; 1 edition (February 20, 2007)
• Language: English
• ISBN-10: 047004599X
• ISBN-13: 978-0470045992
• Product Dimensions: 9.1 x 7.5 x 0.8 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #62,137 in Books (See Top 100 in Books)
  • #4 in Books > Computers & Technology > Microsoft > Spreadsheets

More About the Author

Stephen L. Nelson, MBA, CPA, provides accounting, business advisory, tax planning, and tax preparation services to small businesses. He belongs to the American Institute of CPAs and is a prolific author.

Customer Reviews

Most Helpful Customer Reviews

18 of 18 people found the following review helpful:

5.0 out of 5 stars Very good book on the subject, especially on Pivot Tables, June 23, 2009

By 

Gaetan Lion - See all my reviews
(TOP 1000 REVIEWER)    (REAL NAME)   

Amazon Verified Purchase

This review is from: Excel 2007 Data Analysis For Dummies (Paperback)

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. Different books covering the same overall subject (using Excel to conduct data analysis) could very well cover a fairly different set of topics with not much overlap between them. This is because Excel has so much width to its capabilities, you can easily take it in different directions.

When I looked at the table of content, I noted that Stephen Nelson is huge on Pivot Tables. He probably wrote the only book on data analysis dedicating a full four chapters to Pivot Tables. That was fine with me since I really wanted to learn about them.

In any case, if the book's table of content covers what you want to learn on the subject this is a very good book.

11 of 13 people found the following review helpful:

4.0 out of 5 stars Excel 2007 Data Analysis is Great, March 19, 2007

By 

Bubba T (Ohio) - See all my reviews

Amazon Verified Purchase

This review is from: Excel 2007 Data Analysis For Dummies (Paperback)

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.

3 of 4 people found the following review helpful:

5.0 out of 5 stars Data Analysis, August 17, 2009

By 

M.S. - See all my reviews

This review is from: Excel 2007 Data Analysis For Dummies (Paperback)

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.