- 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.3 out of 5 stars See all reviews (94 customer reviews)
- Amazon Best Sellers Rank: #442,922 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Excel 2007 Bible 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently Bought Together
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 www.j-walk.com/ss.
Top Customer Reviews
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 ›
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.
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!
Excel is such a huge topic, that it is impossible to cover it all in one book. As with all other Excel authors, Walkenbach has omitted some things. The most glaring omission is the Subtotal command (not the function). I am continually amazed at the people who have been using Excel for years and don't know about this command. It is not covered in John's book (at least, I haven't been able to find it even with a PDF search), but the subject is covered pretty well in Help and is easy to find there. The other subject I wish he had included was Advanced Filtering. Advanced Filtering is a true workhorse in Excel. Any heavy user of Excel should know how to use it. I feel it is more valuable to the daily user than the intricacies of array formulas. If he had covered those two topics, I would have given him five stars. Regardless, this is a very good book.
Most Recent Customer Reviews
Very informative book. Step by step guide to get everything you need done efficiently in excel. My BIBLE TO EXCELPublished 7 months ago by Amazon Customer
I know this must be good because I'm one who needs all the help I can muster in such things.Published 9 months ago by Howard C. Mayberry, Jr.
Best overall guide for EXCEL 2007. Very in depth and comprehensive. Dry reading but it helped me with several projects.Published 12 months ago by Robert M.
Never read it because it is too dense. I personally believe the best way to learn things like this is to actually practice with it.Published 14 months ago by Tyler