Deliver to your Kindle or other device

Enter a promotion code
or gift card

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Excel 2007 Data Analysis For Dummies [Kindle Edition]

Stephen L. Nelson
4.1 out of 5 stars  See all reviews (9 customer reviews)

Digital List Price: $26.99 What's this?
Print List Price: $26.99
Kindle Price: $14.99
You Save: $12.00 (44%)

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your email address or mobile phone number.


Amazon Price New from Used from
Kindle Edition $14.99  
Paperback $16.41  
Unknown Binding --  
Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

  • 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

  • File Size: 20835 KB
  • Print Length: 388 pages
  • Page Numbers Source ISBN: 047004599X
  • Publisher: For Dummies; 1 edition (May 21, 2007)
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B004OC01C2
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Lending: Enabled
  • Amazon Best Sellers Rank: #170,677 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?.

Customer Reviews

4.1 out of 5 stars
4.1 out of 5 stars
Share your thoughts with other customers
Most Helpful Customer Reviews
20 of 20 people found the following review helpful
Format:Paperback|Verified Purchase
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.
Comment | 
Was this review helpful to you?
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
Format:Paperback|Verified Purchase
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.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
1.0 out of 5 stars outdated pivot tables June 17, 2012
Format:Paperback|Verified Purchase
the info is outdated for 2007....some info that pertains, but not what I needed to fully understand how to do pivot tables step by step
Comment | 
Was this review helpful to you?
3 of 4 people found the following review helpful
5.0 out of 5 stars Data Analysis August 17, 2009
By M.S.
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.
Comment | 
Was this review helpful to you?
3.0 out of 5 stars All your forumuals are belong to Excel August 21, 2013
Format:Paperback|Verified Purchase
I love Excel. This is one of the few software that actually holds the test of time and keeps seeming to get better. But, getting better also means getting more complicated. This is what makes the "For Dummies" series so valuable. I can say that it would be nice if they added in interactive modules for download or created special forums for those of us who purchase this product to bounce ideas and questions around.
Comment | 
Was this review helpful to you?

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.

What Other Items Do Customers Buy After Viewing This Item?


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category