Start reading Excel 2010 For Dummies Quick Reference on the free Kindle Reading App or on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here.

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 2010 For Dummies Quick Reference [Kindle Edition]

Colin Banfield , John Walkenbach
4.3 out of 5 stars  See all reviews (7 customer reviews)

Digital List Price: $18.99 What's this?
Kindle Price: $10.49
You Save: $8.50 (45%)

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 $10.49  
Plastic Comb $14.05  
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

Find the answers to your most important Excel questions with this reference

John Walkenbach’s name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach—along with Excel expert Colin Banfield—answers your most common and important Excel questions in this easy-to-understand reference.

You'll learn how to open, save, protect, and recover workbook files; add, copy, and delete worksheets; enter and edit data and text; create formulas and functions; audit, format, and print; and more. Highly organized and free of unnecessary jargon, this essential reference allows you to find the answers you’re looking for quickly and easily.

  • Excel gurus Walkenbach and Banfield offer quick and easy answers to common Excel questions
  • Offers information in a highly organized, easy-to-understand format so you can find exactly what you need
  • Includes information on opening, saving, protecting and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing; formatting; printing; and more
  • Covers navigating the user interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more

Excel 2010 For Dummies Quick Reference enables you to spend more time working on your projects rather than trying to figure how to make Excel work for you!

Editorial Reviews

From the Back Cover

Straightforward and up-to-date — the nitty-gritty on working with Excel

Want to spend more time on your projects and less time trying to figure out Excel? This handy, portable guide gives you the facts in an easy-to-use format. Two Excel gurus bring you quickly up to speed on the 2010 version and then lay out the stuff you need to know: how to compare workbooks, manage worksheets, enter dates, work with formulas and functions, and much more.

  • New for 2010 — learn to use the slicer report filter for PivotTables, in-cell charts (called Sparklines), table and PivotTable search filters, interactive PivotChart filters, and PivotTable custom calculations

  • More than one — share workbooks, protect them from unauthorized use, or compare two side-by-side

  • It's relative — use relative, absolute, and mixed references, and convert formulas to values

  • Cell development — edit cell contents, copy cells and ranges, and enter dates, formulas, text, and values

  • Chart your progress — choose a chart, modify its axis, create and add elements, and add context to numbers

  • Tables and more — use tables, PivotTables, and PivotCharts effectively

Open the book and find:

  • A tour of the Excel 2010 window

  • Keyboard shortcuts that save you time

  • How to undo changes and correct mistakes

  • All you need to know about naming constants and formulas

  • Advice on formatting numbers and ranges

  • How to adjust settings and print your worksheet

  • The different types of charts and how to change them

  • What to do with the slicer report filter

Learn to:

  • Navigate the new interface

  • Use the Ribbon and Quick Access toolbar

  • Create formulas and functions

  • Save, protect, and recover workbook files

About the Author

Colin Banfield is an Excel expert with more than 20 years in the telecommunications field.

John Walkenbach, aka Mr. Spreadsheet, has written more than 50 books on Excel and spreadsheet use. Visit his popular Spreadsheet Page at

Product Details

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

Customer Reviews

4.3 out of 5 stars
4.3 out of 5 stars
Share your thoughts with other customers
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
4.0 out of 5 stars Better to get the book September 22, 2012
Format:Kindle Edition|Verified Purchase
I got this on my kindle and it is sometimes difficulte to understand when the pictures and graphs are on different pages. Not like when u get the book and you are able to refer back and forth much easier. Just gave up and am taking a class.
Comment | 
Was this review helpful to you?
2.0 out of 5 stars Not for Kindle June 18, 2014
Format:Kindle Edition|Verified Purchase
I just purchased this for my Kindle. The screenshots are tiny and impossible to see. They don't seem to get any bigger if you enlarge the font. The book might be fine except for that. If you count on the screenshots to understand what the author is explaining, buy a hard copy book, not a Kindle edition.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Excel 2010 for Dummies December 10, 2013
Format:Plastic Comb|Verified Purchase
Good quick reference guide. I like having handy. There are so many things about Excel that require a reference guide if not used daily. This provides that information easily and quickly. It is easy to read and follow the instructions.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars Handy July 23, 2013
Format:Plastic Comb|Verified Purchase
I keep this by my computer at work. It is easy to look things up and try to figure out this version of excel. This version is not intuitive, so the reference is handy.
Comment | 
Was this review helpful to you?

More About the Author

Discover books, learn about writers, read author blogs, and more.

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