Industrial-Sized Deals TextBTS15 Shop Women's Handbags Learn more nav_sap_SWP_6M_fly_beacon Disturbed Fire TV Stick Off to College Essentials Shop Popular Services tmnt tmnt tmnt  Amazon Echo Starting at $99 Kindle Voyage Disney Infinity 3.0 Shop Back to School with Amazon Back to School with Amazon Outdoor Recreation Deal of the Day
Excel 2007 Bible and over one million other books are available for Amazon Kindle. Learn more

Excel 2007 Bible 1st Edition

83 customer reviews
ISBN-13: 978-0470044032
ISBN-10: 0470044039
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
Buy new
More Buying Choices
42 New from $20.26 76 Used from $0.50
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

InterDesign Brand Store Awareness Textbooks
$26.48 FREE Shipping on orders over $35. In Stock. Ships from and sold by Gift-wrap available.

Frequently Bought Together

Excel 2007 Bible + Excel 2007 Formulas + Excel 2007 Power Programming with VBA
Price for all three: $88.53

Buy the selected items together

Editorial Reviews

From the Back Cover

"John Walkenbach provides excellent examples in this book?that Excel users will find very useful."
—David McRitchie, Microsoft MVP

The perennial bestseller—now fully updated for Excel 2007!

Whether you're already a power user or just starting, find out how to get the most out of this major new release of Excel from expert instructor and Microsoft MVP, "Mr. Spreadsheet," John Walkenbach. Each of the book's seven parts thoroughly focuses on key elements, so no matter what your level of expertise, you'll find what you need in the hundreds of examples, techniques, and tips in this comprehensive resource.

  • Master Excel's new "menu-less" Ribbon user interface
  • Understand formulas, functions, tables, worksheets, and workbooks
  • Explore the new unlimited conditional formatting
  • Develop custom functions, program with VBA, and create UserForms
  • Analyze data using external database files and pivot tables
  • Enhance your worksheets with new SmartArt tools
  • Customize the Quick Access Toolbar and save time

The new Page Layout View displays your worksheet exactly as it will be printed

Easily create summary reports of your data with the enhanced PivotTable tool

System Requirements: Please see the CD-ROM appendix for details and complete system requirements.

About the Author

John Walkenbach, a.k.a "Mr. Spreadsheet," is a principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books, including Excel 2003 Formulas and Excel 2003 Power Programming with VBA, as well as articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Paperback: 866 pages
  • Publisher: Wiley; 1 edition (January 3, 2007)
  • Language: English
  • ISBN-10: 0470044039
  • ISBN-13: 978-0470044032
  • Product Dimensions: 7.4 x 1.8 x 9.3 inches
  • Shipping Weight: 3 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (83 customer reviews)
  • Amazon Best Sellers Rank: #144,167 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.

Customer Reviews

Most Helpful Customer Reviews

160 of 161 people found the following review helpful By Ilia Asafiev on December 26, 2007
Format: Paperback
I recently acquired this book for purposes of review and recommendation for Office 2007 literature at work.

John Walkenbach has written many books on the subject of Excel. As such, this book is comprised of summaries of several of his other, more specific publications.

Part 1 of the book goes over spreadsheet basics. This includes working with tables, which is a new Excel feature in 2007. You'll find most information pertinent to basic Excel usage in this section, and will be well on your way.

Part 2 is a summary of J.Walk's Excel 2007 formulas book. It includes the same basic chapters - Text, Date/Time, Count/Sum, Lookup, Financial, and two chapters on Array Formulas. If you already have the formulas book, this is completely useless; if you do not, this is a good overview without the extra details.

Part 3 is a short summary of the Excel 2003 charts and graphs, updated for Excel 2007. It also includes a section on working with graphics and the new conditional formatting features of Excel 2007. The information here is not terribly deep, but gives the basics of working with charts and provides some tips for advanced manipulation that is possible. The chapter on conditional is quite short, considering the number of improvements to this feature that has come about with Excel 2007.

Part 4 is a "miscellaneous" section, encompassing various features such as custom number formats, sharing Excel data, and a number of tips/tricks. Again, many of the features described are given an overview rather than an in-depth treatment, but I found that the essential features are all present and accounted for. There is also some information for working in a networked environment and with the Internet.
Read more ›
2 Comments 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
80 of 87 people found the following review helpful By Read to live on September 10, 2007
Format: Paperback
If you like me, having used Excel for years and all of sudden facing the totally overhauled Excel 2007, scrambling to find your familiar functions, and desparately looking for a book to avoid the fancy Excel 2007 slow you down, and you got this book and read it and will feel a bit being let down...

To start with, you won't learn a lot. Chapter 2, What is New in Excel 2007 is the most valuable one.

I am a heavy user of Pivot table so I read Chapter 34 Introducing to Pivot Table and Chapter 35 Analyzing Data with Pivot Table letter by letter. I have learn very little from these two chapters. As I play around Excel 2007, I actually have figured out much more than what the two chapters have covered.

It seems to me that John was in hurry to write up this book rather than taking time to really provide something useful. Don't get me wrong, I am a big fan of his Excel 2000 Bible and 2003 Bible. I actually own the latter.

If you have any previous Excel bible, arrange a 20 minutes book-store-skim for this book. Everyone is catching up with Excel 2007; you might be a quicker learner yourself.
2 Comments 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
33 of 34 people found the following review helpful By A Work In Progress on November 7, 2007
Format: Paperback
This is one of THE BEST books on Excel 2007! I've compared this book to the following: Excel 2007 the Missing Manual & Excel 2007 Beyond the Manual. I found that the Bible version to be not only a good overview of the changes in Excel 2007, but also a guide that explores the many uses and possibilities of using the program.

It is well organized, detailed and serves as a good resource for new & intermediate. It is not, however for those who are advanced users who are looking for something on advancing their skills in Pivot Tables, VBA or advanced formulas. If you are looking for a book on intricate formulas or a cookbook, then I recommend Formulas and Functions with Microsoft Office Excel 2007 by Paul McFedries. There are also other books out there geared specifically towards VBA and Pivot Tables.

So, to sum it up, it's an outstanding overview and delve into Excel 2007 that will benefit beginners and intermediate users the most and can help this group grow into power users! It also makes a pretty good refresher for advanced users. Either way, you can't go wrong!
1 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
43 of 48 people found the following review helpful By JJ on May 13, 2007
Format: Paperback
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!
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
31 of 37 people found the following review helpful By MomReader on August 5, 2009
Format: Paperback
I honestly get a headache everytime I read this book, you can use it for a quick reference if you have very advanced Excel skills. But, IT'S HORRIBLE AS A LEARNING TOOL..The book I'm mentioning below is a little more expensive but at lot easier to follow than the Excel books for half the price. A tip: search for Excel textbooks used to teach in college rather than those manuals at Barnes and Noble or your local bookstore, you will waste your money.
New Perspectives on Microsoft Office Excel 2007, Comprehensive (Paperback)
by June Jamrich Parsons , etc
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

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Excel 2007 Bible
This item: Excel 2007 Bible
Price: $26.48
Ships from and sold by

Want to discover more products? Check out these pages to see more: online rewards program, you can learn the bible, computer programs for bible