Excel 2010 Bible [Paperback]

John Walkenbach (Author)

Book Description

Publication Date: May 10, 2010 | ISBN-10: 0470474874 | ISBN-13: 978-0470474877 | Edition: 1

A comprehensive reference to the newest version of the world’s most popular spreadsheet application: Excel 2010

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010.

An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won’t find anywhere else.

• Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of Excel
• Delivers essential coverage of all the newest features of Excel 2010
• Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience
• Includes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak

Excel 2010 Bible serves as an excellent resource on all things Excel!

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Editorial Reviews

Review

5/5 stars. ‘…comprehensive and authoritative…gives a user at any level the confidence to self-teach Excel 2010…thorough and genuinely helpful.' (Software Latest.com, December 2010).

From the Back Cover

"John Walkenbach's writing style makes the difficult seem easy in this book that can be used as a reference or read cover to cover. You won't find a more comprehensive book on Excel 2010 than this!"
—Dick Kusleika, Microsoft MVP, DailyDoseOfExcel.com

If Excel can do it, John Walkenbach can show you how

What better way to learn Excel 2010 than from "Mr. Spreadsheet" himself? Excel guru, Microsoft MVP, and author of all the previous top-selling editions of Excel Bible, John Walkenbach provides more than 1,000 pages packed with techniques, tips, and tricks for beginners as well as Excel power users. Discover what's new in Excel 2010, learn shortcuts you didn't know, make the Ribbon interface work for you, and master all the latest ins-and-outs with this must-have guide.

• Get up to speed on everything new in Excel 2010

• Understand functions, charts, worksheets, and workbooks

• Perform magic with array formulas—and even more with Sparklines

• Master "what-if" analysis, Goal Seeking, external database files, and pivot tables

• Develop custom functions, program with VBA, and create UserForms

• Try new slice-and-dice tools to dynamically filter your data

What's on the CD-ROM?

Follow the examples in the book, chapter by chapter, using the bonus materials on the CD-ROM:

• All the examples and workbook files used in the book

• Searchable PDF of the book

System Requirements: See the CD Appendix in the book for details and complete system requirements.

• Preview how your copied text will look
• Spot trends in your data with Sparklines
• Chart your data using Excel's different chart types
• Master Excel formulas for useful worksheets
• Create effective charts suitable for the boardroom
• Analyze and present data with pivot tables

See all Editorial Reviews

Product Details

• Paperback: 1056 pages
• Publisher: Wiley; 1 edition (May 10, 2010)
• Language: English
• ISBN-10: 0470474874
• ISBN-13: 978-0470474877
• Product Dimensions: 7.4 x 1.9 x 9.2 inches
• Shipping Weight: 4 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (81 customer reviews)
• Amazon Best Sellers Rank: #1,203 in Books (See Top 100 in Books)
  • #39 in Books > Computers & Technology

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.

Most Helpful Customer Reviews

126 of 129 people found the following review helpful

5.0 out of 5 stars The best there is July 16, 2010

By twogletree

Format:Paperback|Amazon Verified Purchase

I spent some time in the book store, and then in Microcenter, looking for a book on Excel. Of course I then ordered it from Amazon to save a lot of money. This book is the one you need. It contains just about everything you will ever want to know, from beginner to advanced user. This includes expecially Visual Basic for Applications for advanced users.

The best thing I have found about this book is that it each topic is short and concise. There is no "fluff" in this book. Every sentence has some meaning and the examples (also included on the CD) are straight forward and to the point. There is no wasted space in this book. You will find in "tips" some things that you won't find in other books, or in the Microsoft documentation.

If you are a beginner or advanced user, you will find this book a treasure of information. It should be the first book you buy about Excel 2010.

43 of 43 people found the following review helpful

5.0 out of 5 stars Absolute MUST if you use Excel April 24, 2011

By I'm a mom

Format:Paperback|Amazon Verified Purchase

I have been teaching Excel for years and I always recommend this book to my class. This is by far the best Excel book I have ever found for anyone who uses Excel daily. I have purchased each new version that has come out for the past 3 versions. It is invaluable in helping me to discover and use some of the more obscure functions in Excel.

68 of 78 people found the following review helpful

1.0 out of 5 stars Buyer Beware! June 28, 2012

By 2Wheeler

Format:Paperback|Amazon Verified Purchase

This is the definitive text on Excel 2010. It is both lucid and thorough in its coverage of the world's leading PC spreadsheet software. Unfortunately, the publisher and Amazon have chosen to penalize the user for buying the Kindle edition. I bought an iPad primarily to be able to use ebooks instead of having to lug around heavy texts such as this one. Hence, I was ready to buy the Kindle edition until I realized that it didn't include the contents of the CD that accompanies the printed edition. The CD includes numerous examples, formulas, and VB programs that are referred to extensively in the text. It also includes a searchable PDF file of the entire text, which you can load on your PC and/or iPad. Amazon cleverly hides this information by requiring you to click on a Show More link at the bottom of the book description section. So, if you buy the Kindle edition, you miss critical accompanying information and you don't get the PDF, which would be very useful when you're working at your PC. Moreover, since the PDF can be loaded on your iPad, you in effect get both the printed book and the electronic book for just $1.22 more than the price of the Kindle edition. When I asked Amazon's customer service representative why Amazon doesn't fix this, he said it's the publisher's fault and that Amazon can't do anything about it except transmit customers' negative feedback. As it turns out, there are a number of instances where books that include a CD with the printed edition don't include the CD contents with the Kindle Edition, and not just from this publisher.

There is another issue that somewhat compromises the quality of the text - namely, the quality of the PDF file. There are numerous graphics in the text that show what appears on the screen when using Excel. Most, if not all, of them are difficult or impossible to read in the PDF version; the graphics in the text are readable, though they would be easier to read if they were larger. Still, the printed edition is a much better value than the Kindle edition. If, like me, you decide to buy the printed edition because of the better value but would much rather have the electronic edition, please at least let Amazon and the publisher know that this is not acceptable and will likely jeopardize the wide acceptance of electronic books.

*** UPDATE 07/09/2012 ***

It turns out that buyers of the Kindle edition can get the CD files that accompany the printed edition. I contacted the publisher (Wiley) to complain about not providing the CD files with the Kindle edition and they told me I could download them from their website via a link they would provide, once I had sent them a copy of my purchase confirmation from Amazon. Just go to [...] click on the Ask A Question tab, and tell them what you want. I told Amazon that they need to edit their book description to make sure customers know this.