Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf) [Paperback]

John Walkenbach (Author)

Book Description

Publication Date: February 12, 2007 | ISBN-10: 0470044020 | ISBN-13: 978-0470044025 | Edition: PAP/CDR

• This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be 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 readers won’t find anywhere else
• John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel
• Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
• Includes a valuable CD-ROM with templates and worksheets from the book

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

Editorial Reviews

From the Back Cover

Create killer formulas—Mr. Spreadsheet shows you how

Excel master John Walkenbach has shared his expertise in two previous editions of this bestseller. Now he shows you how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and more with Excel 2007. If you already know your way around the newest Excel and want to concentrate on using formulas to extend its capabilities even further, you've come to the right place.

It's estimated that only about ten percent of Excel users really understand how to get the most out of worksheet formulas. If you're ready to join that elite group, here's your membership kit.

CD-ROM INCLUDES:

Sample files for tutorials

See the CD appendix for details and complete system requirements.

Mr. Spreadsheet's Success Techniques

Technique # 1 Master operators, error values, and absolute vs. relative references

Technique # 2 Find errors and debug formulas

Technique # 3 Use pivot tables to eliminate formulas

Technique # 4 Create single- and multi-cell array formulas

Technique # 5 Build custom functions with VBA

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 40-plus books include Excel 2003 Power Programming with VBA, Excel Charts, and John Walkenbach's Favorite Excel Tips & Tricks, all published by Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.

Product Details

• Paperback: 840 pages
• Publisher: Wiley; PAP/CDR edition (February 12, 2007)
• Language: English
• ISBN-10: 0470044020
• ISBN-13: 978-0470044025
• Product Dimensions: 7.4 x 1.8 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 (24 customer reviews)
• Amazon Best Sellers Rank: #276,576 in Books (See Top 100 in Books)

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

43 of 45 people found the following review helpful

5.0 out of 5 stars Get this book, even if you use OpenOffice Calc! March 22, 2007

By Zaine Ridling

Format:Paperback

John Walkenbach is well established as a great spreadsheet mind and is not afraid to share the shortcomings of any software, including Excel 2007. Excel 2007 Formulas continues the tradition of providing, explaining, and demonstrating how formulas work and how you don't have to be intimidated by them. Everything is covered, and I mean everything. And just a note: even if you use StarOffice/OpenOffice Calc, buy this book since almost all the formulas listed transfer seamlessly into the Open Source spreadsheet, too -- a great value, indeed!

19 of 19 people found the following review helpful

4.0 out of 5 stars A great reference book October 3, 2007

By Renan Picado

Format:Paperback

With the recent changes on Excel 2007, in which there were several cosmetic and functional changes, this book is a good option for reference. The author is a real master, no doubt about it, on the CD provided you will see some examples that you would never expected to get out of excel. The only real complaint is in regards to the screen captures on the book, some of them are so POOR quality on resolution that you can hardly see it.
However, I would recommend you this book for those interested on developing sound data analysis skills in the application.

17 of 20 people found the following review helpful

5.0 out of 5 stars When Your Good,....Your Good! May 13, 2007

By JJ

Format:Paperback

The Author really knows his stuff!!!

Again an accurate, concise, extensive reference tool for the beginner as well as the advanced user. This is my fourth excel book by Mr. Walkenbach and they are all of equal caliber. They all contain general background information as well as information dealing with other programming areas of excel (so that even if you only purchase a book like the VBA programming guide, you will still learn about macro programming and other general excel functions). Like all his books, this one gives the user a complete library of useful and professional approaches towards working with and solving excel problems. Good Job Mr Walkenbach!