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

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Excel 2010 All-in-One For Dummies [Kindle Edition]

Greg Harvey
4.3 out of 5 stars  See all reviews (58 customer reviews)

Digital List Price: $34.99 What's this?
Print List Price: $34.99
Kindle Price: $19.49
You Save: $15.50 (44%)


Amazon Price New from Used from
Kindle Edition $19.49  
Paperback $20.81  
Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Book Description

A comprehensive, up-to-date, user-friendly guide to Excel 2010

Excel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more.

Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.

  • Excel is the leading spreadsheet/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface
  • For Dummies books are the bestselling guides to Excel, with more than three million copies sold
  • Excel 2010 All-in-One For Dummies covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions
  • Eight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA.

Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know.

Customers Who Bought This Item Also Bought

Editorial Reviews Review

More to Explore: See More Excel 2010 Resources


Excel 2010 For Dummies Excel 2010 All-in-One For Dummies Excel 2010 eLearning Kit For Dummies Excel 2010 Basics and Advanced For Dummies eLearning Course Access Code Card
Guide Type
Comprehensive Tutorial
Training Guide and Interactive Course
Web-Based Training Software
Audience Level
Intermediate to Advanced
Beginner to Intermediate
Beginner to Intermediate
List Price
Greg Harvey
Greg Harvey
Faithe Wempen
Faithe Wempen
Publication Date
April 2010
May 2010
January 2012
October 2012
For Dummies
For Dummies
For Dummies
For Dummies
Kindle book
Brief Description
Top Excel 2010 title on the market. Goes over the basics of Excel and helps with the need-to-know Excel skills.
Comprehensive, up-to-date, user-friendly guide to Excel 2010.
Includes full-color tutorial book along with fully interactive, eLearning course on CD-ROM.
Code for 6-month access to online eLearning course with interactive lessons including audio and video.

From the Back Cover

Here's everything you need to know about using Excel — in one handy package!

Excel is such a powerhouse, it takes eight self-contained minibooks to cover all its features! Open this All-in-One and find just what you need to know, from how to use the Ribbon interface and Backstage View and how to set up your first spreadsheet to collaborating on a worksheet, presenting results with cool charts and graphs, and understanding formulas and functions.

  • Welcome to 2010 — explore the new user experience, learn where to get help, and customize your Excel

  • Workin' with worksheets — learn to build, format, edit, proof, manage, and print them

  • Formula for success — find out what formulas and functions do and how to use them

  • Share and collaborate — discover how to send workbooks out for review and incorporate input from multiple users

  • Results that are pretty — find out which type of chart shows off your data to best advantage

  • Keeping data in line — learn to maintain, sort, and filter data lists using Excel

  • Analyze this — use Excel's computational ability to predict possible outcomes

  • Making macros — use Visual Basic® for Applications, record macros, edit VBA code, and make Excel do your bidding

Open the book and find:

  • How to navigate the Ribbon and Backstage View

  • Shortcuts for switching from older versions

  • Tricks for eliminating Text to Speech errors

  • All about functions and how they work in formulas

  • How to secure data and still enable user edits

  • How to use line charts, pie charts, and scatter charts

  • Tips for creating macros and custom functions

  • How to perform what-if analysis

Product Details

  • File Size: 12217 KB
  • Print Length: 792 pages
  • Publisher: For Dummies; 1 edition (April 20, 2010)
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B005ZIPQ60
  • Text-to-Speech: Enabled
  • X-Ray:
  • Lending: Enabled
  • Amazon Best Sellers Rank: #50,232 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

Customer Reviews

Most Helpful Customer Reviews
27 of 29 people found the following review helpful
3.0 out of 5 stars Hard for a rookie February 5, 2012
Pros: comprehensive book, and for sure it has tons of info you would ever need.

Cons: 1: quite hard to read and you have to be really concentrated.

2: it mentions a lot of buttons' names throughout the book, but the name of a button is only differentiated from the rest of the text by giving it an uppercase letter, that is it. As a result, you have to be super super concentrated, and so it slows you down.(why not give it a box, an underline, or a tiny real-time snapshot).

3. There are even some errors for button names (I cannot believe it! Maybe the author's Excel 2010 is not the same as mine???). For example, this book says "click the Funciton Wizard button on the Formula bar...", but heck, my Excel 2010 shows "Insert Function", So go figure how that feels for a rookie.

4. There should be more exampels to illustrate how to use the programs, but this book reads very boring like a gigantic instruction manual.

I am new to learn Excel 2010, but know other job related softwares; and I think this book is not a great book for those who have no basic computer know-how.
Comment | 
Was this review helpful to you?
9 of 9 people found the following review helpful
3.0 out of 5 stars Good Book Bad Illustrations September 24, 2012
Format:Kindle Edition|Verified Purchase
I got the Kindle addition thinking I could use my laptop, while using Excel on my desktop. You can not make out the charts, diagrams, illustrations in the E-Book.
This is not very helpful, when you are teaching yourself Excel. The hard copy would be better.
Was this review helpful to you?
22 of 28 people found the following review helpful
4.0 out of 5 stars Excel for Dummies All-In-One Book March 8, 2011
By Barry
Format:Paperback|Verified Purchase
This book is great in that I've used for solutions and answers when in the process of using Excel. It has adequately shown me how to use Excel more effectively that I was able to before. I was going to take a course (for ~$100), but this is a better solution because it only gives me what I need at the time and not what I don't need!
Comment | 
Was this review helpful to you?
7 of 8 people found the following review helpful
5.0 out of 5 stars A great blanket on Excel March 11, 2012
Format:Kindle Edition|Verified Purchase
Harvey does a great job organizing and covering all the important topics in Excel. I regularly use this book as a quick reference, but having read it cover to cover I highly recommend it for all levels of users.
Comment | 
Was this review helpful to you?
7 of 8 people found the following review helpful
5.0 out of 5 stars nice reference and learning tool March 9, 2012
Format:Paperback|Verified Purchase
I've used excel for 10 years or so, and what I've learned about it has been just what I needed to learn in order to perform data analysis as a portion of my job. Using this book as a self-teaching tool has given me a much firmer foundation in the program. I've also found it helpful as a resource on my desk to turn to in order to perform specific functions. (In fact, so have others in my office) Pleased with the purchase on both a personal and professional level.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
4.0 out of 5 stars Not for graphing November 4, 2012
By R. Hall
This book does not include very much information on graphing; that is, it does not include much at all on making graphs. If you need graphing, look elsewhere. The 20 word minimum is a pain.
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
5.0 out of 5 stars great support text December 31, 2012
By Richard
Format:Paperback|Verified Purchase
This item was exactly as described, fast shipping. This is a great source for remembering tasks not used often.A must have for excel users.
Comment | 
Was this review helpful to you?
5 of 6 people found the following review helpful
5.0 out of 5 stars Heavy Excel User January 21, 2013
Format:Paperback|Verified Purchase
I actually thought my Excel skill level was intermediate. However,
compared to my co-workers, I feel like a beginner. So I purchased
this book to add to the skills I already have, since many employers
use this software and are looking for advanced users. And you can
never go wrong with these "Dummies" publications. I also have one
for Quickbooks, that I refer to at work. It is well worth the small investment.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars Great!
Just what I was looking for!
Published 9 days ago by Angel Holbrook
5.0 out of 5 stars Lots of info!!
Enjoying this guide to Excel. I can understand it very well in these terms it was written in! I keep it by my desk at work. Lots of info!
Published 1 month ago by Avsfan
4.0 out of 5 stars Good book...helpful
Good book, very important information and helpful with understanding this new language of computers and technology. Would recommend to people
Published 2 months ago by derek begay
4.0 out of 5 stars so far so good
I'm not sure yet. I just downloaded this book, the app is requiring a review before I can read it.
Published 4 months ago by Terah
4.0 out of 5 stars Works for me.
Since I am a borderline idiot when it comes to Excel, this book has been a godsend. I am able to navigate myself through the spreadsheet and actually understand what I am doing.
Published 4 months ago by John
4.0 out of 5 stars Excel 2010 for Dummies
Very informative, easy to read instructions. It's a very big book, a little hard to find information I wanted in the index, but once I found what I needed: Very good!
Published 4 months ago by Anne Zangari
4.0 out of 5 stars good and bad
I wanted to know some easy things and couldn't find the information.
On other things the book was helpful.
More for people who are doing spread sheets all day.
Published 4 months ago by Rose Angelo
5.0 out of 5 stars I'm a Dummy
this book is perfect for someone just learning Excel. it breaks everything down into the smallest increment as though you know nothing!
Published 4 months ago by Karen Holland
5.0 out of 5 stars good product
Just what I was looking for all in one book. Gives good answers with very little effortNo worries, just right.
Published 5 months ago by Ray Beckmann
5.0 out of 5 stars Great for Excel Users
This is an excellent book for beginners as well as those who have a good knowledge of Excel. It is very easy to use.
Published 6 months ago by wqueenz
Search Customer Reviews
Search these reviews only

More About the Author

Greg Harvey has authored tons of computer books, the most recent being Excel Timesaving Techniques For Dummies and Roxio Easy Media Creator For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, he went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience, the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

What Other Items Do Customers Buy After Viewing This Item?


Have something you'd like to share about this product?
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for Similar Items by Category