John Walkenbach's Favorite Excel 2010 Tips & Tricks (Mr. Spreadsheet's Bookshelf) [Paperback]

John Walkenbach (Author)

Book Description

ISBN-10: 0470475374 | ISBN-13: 978-0470475379 | Publication Date: July 13, 2010 | Edition: 1

Build robust Excel 2010 apps quickly and efficiently

Known as "Mr. Spreadsheet," John Walkenbach's name is synonymous with excellence in computer books that explain the complexities of various topics. With this collection of favorite Excel tips and tricks, you get a unique look at ways to make Excel 2010 more efficient than you ever imagined.

Packed with easy-to-understand advice regarding all aspects of Excel, this book shares improved ways of speeding up application development with Excel and maximizing the power of Excel to create robust applications.

• Addresses the extensive changes to the 2010 version of Excel and shares tricks and shortcuts for making your Excel experience as successful and efficient as possible
• Reveals ways to deal with function arguments, create "impossible" charts, and tame the Ribbon bar
• Discusses absolute vs. relative references, change data entry orientation, and sort more than three columns
• Demonstrates ways to enter fake data for testing purposes

With John Walkenbach's Favorite Excel 2010 Tips and Tricks, you'll get a jump start on mastering the extensive changes to the 2010 version of Excel.

Editorial Reviews

From the Back Cover

Work more efficiently, and get the most out of Excel 2010 — Mr. Spreadsheet shows you how

With this collection of Mr. Spreadsheet's favorite Excel tips and tricks, you get a unique look at ways to make Excel 2010 more efficient than you've ever imagined.

The book is filled with easy-to-understand suggestions that touch on all aspects of Excel 2010, including how to work with the Backstage View and how to use the new AGGREGATE function. This hands-on resource will help you maximize the power of Excel to create robust applications.

With John Walkenbach's Favorite Excel 2010 Tips & Tricks, you'll get a jump-start on mastering the extensive changes to the newest version of Excel.

Let Mr. Spreadsheet show you how to:

• Maximize your screen real estate by hiding the Ribbon

• Create a drop-down list in a cell

• Update the fonts in your old workbooks

• Understand the secret of range names

• Add images to your charts

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, Excel 2010 Formulas, and the Excel 2010 Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.

Product Details

• Paperback: 504 pages
• Publisher: Wiley; 1 edition (July 13, 2010)
• Language: English
• ISBN-10: 0470475374
• ISBN-13: 978-0470475379
• Product Dimensions: 9.4 x 7.4 x 1.1 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 2.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #385,635 in Books (See Top 100 in Books)

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

2.0 out of 5 stars For new users only, October 31, 2011

By 

rki1966 - See all my reviews

Amazon Verified Purchase

This review is from: John Walkenbach's Favorite Excel 2010 Tips & Tricks (Mr. Spreadsheet's Bookshelf) (Paperback)

I purchased this book hoping to get new tips in 2010. This book is useful to new users but not worth buying if you have used prior excel versions.

This is just a repeat of his other excel books with a couple of extra features in 2010.