Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Excel Data Analysis For Dummies [Paperback]

Stephen L. Nelson
5.0 out of 5 stars  See all reviews (1 customer review)
List Price: CDN$ 35.99
Price: CDN$ 22.56 & FREE Shipping on orders over CDN$ 25. Details
You Save: CDN$ 13.43 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Wednesday, September 17? Choose One-Day Shipping at checkout.
Save Up to 50% on "For Dummies" Books
Lighthearted but not lightweight, For Dummies books are great references not only for tackling new subjects but also for brushing up on subjects with which you're already familiar. Get results while saving up to 50%. See more.
There is a newer edition of this item:
Excel 2007 Data Analysis For Dummies Excel 2007 Data Analysis For Dummies
CDN$ 20.15
In Stock.
Join Amazon Student in Canada


Book Description

Aug. 9 2002 0764516612 978-0764516610 1
So here’s a funny deal: You know how to use Excel. You know how to create simple workbooks. And how to print stuff. And you can even, with just a little bit of fiddling, create cool-looking charts. But sometimes you wish that you could do more with Excel, such as how to use Excel to really gain insights into information, the data, that you work with in your job.

Using Excel for this kind of stuff is what Excel Data Analysis For Dummies is all about. This is a book that assumes that you want to use Excel to learn new stuff, discover new secrets, and gain new insights into the information you’re already working with in Excel.

Ready to take Excel to the next level? This plain-English guide covers all of these concepts, and more, to ensure that you’re using Excel to its fullest capacity:

  • Harnessing information in lists
  • Querying external databases and Web pages tables
  • Cleaning data with text functions
  • Building and working with PivotTables
  • Customizing PivotCharts
  • Using the statistics functions
  • Understanding Optimization Modeling

If all this talk of statistics and advanced tools makes you light-headed, don’t worry. Excel Data Analysis For Dummies distills the most important fundamentals into everyday language. You’ll find just enough information to help you get your work done – without leaving you gasping for air in a sea of technobabble. It’d be a real shame if you didn’t at least know what bells and whistles Excel has to offer and the basic steps that you need to use them.


Special Offers and Product Promotions

  • Join Amazon Student in Canada


Customers Who Bought This Item Also Bought


Product Details


Product Description

From the Back Cover

Get tips on PivotTables, statistics functions, Solver, and more!

Advanced Excel tools and techniques – explained in plain English!

The fun and easy way™ to take Excel to the next level and tame your data

Excel spreadsheets are a fact of life. But if you’re like most people, you probably don’t take full advantage of Excel’s data analysis tools. That’s where this book comes in. 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.

The Dummies Way

  • Explanations in plain English
  • "Get in, get out" information
  • Icons and other navigational aids
  • Tear-out cheat sheet
  • Top ten lists
  • A dash of humor and fun

Get smart! @www.dummies.com

  • Find listings of all our books
  • Choose from many different subject categories
  • Sign up for daily eTips at www.dummiesdaily.com

About the Author

Stephen L. Nelson (Redmond, WA) writes about business application software and using technology in business. Nelson, the author of Quicken For Dummies, QuickBooks For Dummies, and more than 100 other titles is an M.B.A. and C.P.A. A Wall Street Journal article called Nelson "The Louis L' Amour of computer book writers."

Inside This Book (Learn More)
First Sentence
First things first. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most helpful customer reviews
3 of 3 people found the following review helpful
5.0 out of 5 stars New tricks for an old dog May 19 2004
By Dave
Format:Paperback
I've been using Excel for years, but I've always been frustrated by the more advanced stuff in Excel. Things like pivot tables and pivot charts, or the super-powerful but mega-confusing VLOOKUP function. Sometimes I'd get lucky and figure out how to get one of these things to work, but most times I'd have to ask a co-worker to figure it out for me.
Now, I'm starting to be the guy that folks are coming to for help with advanced Excel stuff. This book is fantastic, and for the first time I'm starting to really use Excel for something more advanced than the Sum button!
Here's the table of contents from my copy of the book. Some of the chapters might sound intimidating, but believe me, this book is fun and easy to read:
Part I: Where's the Beef?
Chapter 1: Introducing Excel Lists.
Chapter 2: Grabbing Data from External Sources.
Chapter 3: Scrub-a-Dub-Dub: Cleaning Data.
Part II: PivotTables and PivotCharts.
Chapter 4: Working with PivotTables.
Chapter 5: Building PivotTable Formulas.
Chapter 6: Working with PivotCharts.
Chapter 7: Customizing PivotCharts.
Part III: Advanced Tools.
Chapter 8: Using the Database Functions.
Chapter 9: Using the Statistics Functions.
Chapter 10: Descriptive Statistics.
Chapter 11: Inferential Statistics.
Chapter 12: Optimization Modeling with Solver.
Part IV: The Part of Tens.
Chapter 13: Almost Ten Things You Ought to Know about Statistics.
Chapter 14: Almost Ten Tips for Presenting List Results and Analyzing Data.
Chapter 15: Ten Tips for Visually Analyzing and Presenting Data.
Part V: Appendix.
Appendix: Glossary of Data Analysis and Excel Terms.
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.5 out of 5 stars  8 reviews
60 of 66 people found the following review helpful
5.0 out of 5 stars New tricks for an old dog May 19 2004
By Dave - Published on Amazon.com
Format:Paperback
I've been using Excel for years, but I've always been frustrated by the more advanced stuff in Excel. Things like pivot tables and pivot charts, or the super-powerful but mega-confusing VLOOKUP function. Sometimes I'd get lucky and figure out how to get one of these things to work, but most times I'd have to ask a co-worker to figure it out for me.
Now, I'm starting to be the guy that folks are coming to for help with advanced Excel stuff. This book is fantastic, and for the first time I'm starting to really use Excel for something more advanced than the Sum button!
Here's the table of contents from my copy of the book. Some of the chapters might sound intimidating, but believe me, this book is fun and easy to read:
Part I: Where's the Beef?
Chapter 1: Introducing Excel Lists.
Chapter 2: Grabbing Data from External Sources.
Chapter 3: Scrub-a-Dub-Dub: Cleaning Data.
Part II: PivotTables and PivotCharts.
Chapter 4: Working with PivotTables.
Chapter 5: Building PivotTable Formulas.
Chapter 6: Working with PivotCharts.
Chapter 7: Customizing PivotCharts.
Part III: Advanced Tools.
Chapter 8: Using the Database Functions.
Chapter 9: Using the Statistics Functions.
Chapter 10: Descriptive Statistics.
Chapter 11: Inferential Statistics.
Chapter 12: Optimization Modeling with Solver.
Part IV: The Part of Tens.
Chapter 13: Almost Ten Things You Ought to Know about Statistics.
Chapter 14: Almost Ten Tips for Presenting List Results and Analyzing Data.
Chapter 15: Ten Tips for Visually Analyzing and Presenting Data.
Part V: Appendix.
Appendix: Glossary of Data Analysis and Excel Terms.
10 of 12 people found the following review helpful
1.0 out of 5 stars Before you buy this book!!!!! Jan. 1 2009
By Daniel - Published on Amazon.com
Format:Paperback
This book is only appropriate for the older Excel additions. If you own Excel 2007 this book will do nothing for you!
4 of 6 people found the following review helpful
5.0 out of 5 stars Excelling at Analysis March 5 2008
By L. J. Oja - Published on Amazon.com
Format:Paperback
The world of mathematical analysis is changing, and for the people involved, doing so at ever younger ages. As a Physics teacher, much of the mathematical modeling or problem solving strategies that come first to a student is something that I might say as a "brute force" method. While not an elegant method sometimes, the computer in general, or graphing calculators in particular are able to handle the demands of a student's "brute force" method of problem attack.

While the elegance of some mathematics takes considerable practice, and perhaps intuition, it has been this feature that has kept many people from the "hard sciences", and engineering. Or, so I would suggest having taught both in secondary and post-secondary. Technology has changed all of this, but it would seem that the full impact of this will take some time to be felt by everyone.

This book sees to much of the analysis possible with the Excel spreadsheet. There are enormous sections that are easily understood by High School students, and with a little coaching can be used to work with experimental data. The laboratory work that many students are able to produce is of exceptional quality, and gratifying to experience.

On the flip side of this same coin is the ability of teachers to quickly check results, and look at the quality of data used.

Material is easily understood, and with functions explained in layperson terminology, the book accomplishes not simply the how, but the why as well. I would recommend that this book is purchased by anyone who can help students learn how to use a spreadsheet.

Currently, I am considering the other Excel spreadsheet books on closely allied areas, and hope that they are as well written, and organized as this book.
3.0 out of 5 stars Just what a couple of my students needed Oct. 14 2013
By James E. Breneman - Published on Amazon.com
Format:Paperback|Verified Purchase
Just what beginning EXCEL users need.. gave this one to another one of my students, who had never used EXCEL before... Seems to be happy with the book!
3.0 out of 5 stars Fair, worth keeping. Dec 22 2010
By Kerrpe - Published on Amazon.com
Format:Paperback|Verified Purchase
This book is a bizarre mix of basics (how to create a list, change the color of a chart) and seriously advanced (heavy customization, detailed descriptions of every statistical and analytical function), without much in the middle.
I wouldn't consider this a dummies book at all, but it's a nice addition to my library for the function descriptions. If you don't have a clue what you are doing, start elsewhere.
Search Customer Reviews
Only search this product's reviews

Look for similar items by category


Feedback