Excel 2010 Formulas (Mr. Spreadsheet's Bookshelf) and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $49.99
  • Save: $32.27(65%)
Rented from RentU
To Rent, select Shipping State from options above
Due Date: May 28, 2015
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
FREE Shipping on orders over $35.
Used: Acceptable | Details
Sold by RentU
Condition: Used: Acceptable
Comment: Fast shipping from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $35. Overnight, 2 day and International shipping available! Excellent Customer Service.. May not include supplements such as CD, access code or DVD.
Access codes and supplements are not guaranteed with used items.
Qty:1
  • List Price: $49.99
  • Save: $17.51 (35%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Sell yours for a Gift Card
We'll buy it for $11.65
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Excel 2010 Formulas Paperback – May 24, 2010

ISBN-13: 978-0470475362 ISBN-10: 0470475366 Edition: 1st

Buy New
Price: $32.48
Rent
Price: $17.71 - $17.72
38 New from $24.99 22 Used from $21.93
Rent from Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$17.71
$32.48
$24.99 $21.93
Year-End%20Deals%20in%20Books

Frequently Bought Together

Excel 2010 Formulas + Excel 2010 Bible + Excel 2010 Power Programming with VBA
Price for all three: $88.14

Buy the selected items together
NO_CONTENT_IN_FEATURE

Using the New AGGREGATE Function
Learn more about the AGGREGATE Function, a new feature introduced in Excel 2010 [PDF].

Product Details

  • Paperback: 816 pages
  • Publisher: Wiley; 1 edition (May 24, 2010)
  • Language: English
  • ISBN-10: 0470475366
  • ISBN-13: 978-0470475362
  • Product Dimensions: 7.4 x 1.7 x 9.2 inches
  • Shipping Weight: 2.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (39 customer reviews)
  • Amazon Best Sellers Rank: #63,845 in Books (See Top 100 in Books)

Editorial Reviews

From the Back Cover

Follow Mr. Spreadsheet's formula for Excel success

Experts estimate that barely 10 percent of Excel users understand how to make the most of worksheet formulas. If you already know your way around Excel basics, "Mr. Spreadsheet" John Walkenbach can help you master formulas to gain greater Excel functionality.

First, he shows you exactly what a formula is, how to create one, and what formulas can do. Then you'll learn about using functions in your formulas. Finally you'll explore specific types of formulas that can help you on multiple levels, such as financial and array formulas.

You'll learn how to apply formulas to charts and pivot tables, troubleshoot your formulas, develop custom functions, and much more.

Let Mr. Spreadsheet show you how to:

  • Master the new functionality in Excel 2010

  • Understand and use various lookup formulas

  • Create financial formulas for borrowing or investing

  • Work with formulas for conditional formatting

  • Develop custom worksheet functions using VBA

CD-ROM INCLUDES:

  • Workbook files for all examples used in the book

  • The entire book in a searchable PDF file

See Appendix D for complete system requirements.

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 50-plus books include Excel 2010 Power Programming with VBA, John Walkenbach's Favorite Excel 2010 Tips & Tricks, and the Excel 2010 Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.

More About the Author

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the world's foremost authority on Microsoft Excel. His fifty-plus Excel books include Excel 2013 Power Programming with VBA, Excel 2013 Formulas, and the bestselling Excel 2013 Bible, all published by Wiley. He has also written hundreds of articles and software reviews, and created the award-winning Power Utility Pak add-in for Excel.

John lives in Tucson, Arizona. He also plays the banjo - but don't let that prevent you from buying his books.

Customer Reviews

This book is a continuation of a great series of Excel books.
John T. Wesner
It includes all of the Excel functions and formulas with many examples in the book and on CD.
Phillip A. Pitalo
I am giving this as a Christmas gift and expect the CD to be present in the book.
Larry R.

Most Helpful Customer Reviews

8 of 9 people found the following review helpful By Blackwood02 on February 22, 2012
Format: Paperback Verified Purchase
Excel 2010 Formulas is a great book. I have learned a lot about how to work with Excel formulas. The background on the differences between Excel 2010 and older versions is very helpful, also. The author does not leave you hanging if you are still using older versions, he has included older versions of many of the formulas so the book is "backward compatible". You may find it helpful to skip ahead to the chapter on arrays before reading earlier chapters because some of the formulas use arrays. This should not be a problem unless you insist on reading strictly front to back.
Very highly recommended.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 7 people found the following review helpful By fiigmo on February 11, 2012
Format: Paperback Verified Purchase
I highly commend this book to "power users" to utilize the extensive features of Excel. As the author makes clear on page 1, this book is NOT for beginners! Because I categorize myself as an "advanced beginner" it became necessary for me to augment this book with others--just to gain proper perspective and understanding. But this book IS highly recommended. By waiting a couple of months post-purchase to write this review, my opinion is that it is hard to imagine not having this book available as a resource.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By D. Hardin on June 17, 2013
Format: Kindle Edition Verified Purchase
Very comprehensive manual. Lot's of detail. Can be a bit overwhelming if you don't use the appendix to look up formulas.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Quantumwoman on March 24, 2013
Format: Paperback Verified Purchase
This book provides a great start when you're looking for a formula. You can count on the formulas in the book to provide a quick solution to a problem, or to adapt one to your own spreadsheets.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By alex20850 on March 23, 2013
Format: Paperback Verified Purchase
I call Excel the ginsu [see Wikipedia] knife for data files and this book is a wonderful way to learn how to use Excel. I found it easy to read and a fun way to learn.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Bill on January 13, 2013
Format: Paperback Verified Purchase
The author responded to my questions regarding a Microsoft add-on but suggested use of the Microsoft Excel Forum as well. The book is well worth it to novices and intermediate level users.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Frank Mellott on January 12, 2013
Format: Paperback Verified Purchase
Not for rookies, but if you know Excel and need a handy reference, this is one of the best for the formulas.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 18 people found the following review helpful By Arthur Hotchkiss on March 31, 2011
Format: Paperback Verified Purchase
This book is another excellent resource product by John Walkenbach. It provides Excel users with in-depth information on how to take their spreadsheets to the next level and beyond. Like previous books by Mr. Walkenbach, one gets concise, clear and to the point information on the many intricate features available in Microsoft Excel.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again