Excel(r) 2007 Bible and over 360,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

 

or
Sign in to turn on 1-Click ordering.
 
 
Express Checkout with PayPhrase
What's this? | Create PayPhrase
Sorry!
More Buying Choices
68 used & new from $22.90

Have one to sell? Sell yours here
 
   
Excel 2007 Bible
 
 
Start reading Excel(r) 2007 Bible on your Kindle in under a minute.

Don’t have a Kindle? Get your Kindle here.
 
  

Excel 2007 Bible (Paperback)

~ (Author)
Key Phrases: row labels, page layout view, field list, Getting Started, Analyzing Data, Excel Options (more...)
3.7 out of 5 stars  See all reviews (25 customer reviews)

List Price: $39.99
Price: $25.19 & this item ships for FREE with Super Saver Shipping. Details
You Save: $14.80 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Upgrade this book for $7.99 more, and you can read, search, and annotate every page online. See details
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Wednesday, November 11? Choose One-Day Shipping at checkout. Details
51 new from $23.36 17 used from $22.90

Formats

Amazon Price New from Used from
  Kindle Edition $20.15 -- --
  Paperback $25.19 $23.36 $22.90

Frequently Bought Together

Excel 2007 Bible + Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf) + Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
Price For All Three: $85.02

Show availability and shipping details

  • This item: Excel 2007 Bible by John Walkenbach

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf) by John Walkenbach

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) by John Walkenbach

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

Microsoft Word 2007 Bible

Microsoft Word 2007 Bible

by Herb Tyson
4.0 out of 5 stars (5)  $26.39
PowerPoint 2007 Bible

PowerPoint 2007 Bible

by Faithe Wempen
3.2 out of 5 stars (4)  $26.39
Access 2007 Bible

Access 2007 Bible

by Michael R. Groh
2.8 out of 5 stars (13)  $31.49
Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

by John Walkenbach
4.2 out of 5 stars (32)  $31.49
John Walkenbach's Favorite Excel 2007 Tips & Tricks (Mr. Spreadsheet's Bookshelf)

John Walkenbach's Favorite Excel 2007 Tips & Tricks (Mr. Spreadsheet's Bookshelf)

by John Walkenbach
4.7 out of 5 stars (7)  $26.39
Explore similar items

Editorial Reviews

Product Description

  • 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 liworld’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.



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.


Product Details

  • Paperback: 912 pages
  • Publisher: Wiley (January 3, 2007)
  • Language: English
  • ISBN-10: 0470044039
  • ISBN-13: 978-0470044032
  • Product Dimensions: 9.2 x 7.6 x 2 inches
  • Shipping Weight: 3 pounds (View shipping rates and policies)
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (25 customer reviews)
  • Amazon.com Sales Rank: #2,247 in Books (See Bestsellers in Books)

    Popular in these categories: (What's this?)

    #1 in  Books > Computers & Internet > Software > Spreadsheets
    #1 in  Books > Computers & Internet > Microsoft > Applications > Excel

More About the Author

John Walkenbach
Discover books, learn about writers, read author blogs, and more.

Visit Amazon's John Walkenbach Page

Inside This Book (learn more)




What Do Customers Ultimately Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(20)

Your tags: Add your first tag
 

 

Customer Reviews

25 Reviews
5 star:
 (11)
4 star:
 (5)
3 star:
 (4)
2 star:
 (1)
1 star:
 (4)
 
 
 
 
 
Average Customer Review
3.7 out of 5 stars (25 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
70 of 70 people found the following review helpful:
4.0 out of 5 stars Excel 2007 bible, December 26, 2007
By Ilia Asafiev (Maryland, USA) - See all my reviews
(REAL NAME)   
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.

Part V deals with data analysis, for operations contained on the Data tab of the Excel 2007 ribbon. Most notably, there is a chapter on using MS Query, and two chapters about pivot tables. Part V also covers Goal Seek and Solver, and provides an overview of the tools included with the Analysis ToolPak. This exposes the reader to the features, but does not provide a whole lot of examples, although J.Walk's examples do tend to showcase just how far you can take some of the Excel features.

Finally, Part VI is a (very brief) summary of Excel 2007 Power Programming. It covers custom user-defined worksheet functions, user forms, and workbook events. There is also a number of examples of code that's readily useable in your own projects and Excel-based solutions. This section is enough to get you started, particularly if you have some programming experience, but if you want to get serious with VBA, this will only get your foot in the door.

Overall, this book is perfect for beginners and intermediate users who do not have a lifetime to devote to Excel. Granted, this book is pretty long, but as I mentioned throughout, it's to the point and not excessively verbose. I think of it as an extended tutorial walkthrough of the different Excel functionality. It does not include case studies or exhaustive spreadsheet solution examples. For advanced users, a vast majority of chapters will be unnecessary.
Comment Comment (1) | Permalink | Was this review helpful to you? Yes No (Report this)



 
38 of 41 people found the following review helpful:
3.0 out of 5 stars Make do with this book if you can't find a better one, September 10, 2007
By Read to live "LLT" (Toronto, ON Canada) - See all my reviews
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.



Comment Comment (1) | Permalink | Was this review helpful to you? Yes No (Report this)



 
35 of 39 people found the following review helpful:
5.0 out of 5 stars Right on the Money!!!, May 13, 2007
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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Excellent to advance in XL
I'm a moderate to heavy (depending on the day) user of XL. I owned one of the previous books from this author and find both, the old and new, superb in the sense that they let me... Read more
Published 28 days ago by Manuel Celada

4.0 out of 5 stars good.
My package got lost so it took me quite a while to get this book.
But it was brandnew as it decribed.
Published 1 month ago by Mi Lee

1.0 out of 5 stars Don't waste your money... buy this instead
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.. Read more
Published 3 months ago by A. Aldana

1.0 out of 5 stars Kindle Users beware
I almost bought this thinking I would be able to download the CD ROM material, but in the small print it says the Kindle Edition does NOT have access to the CD ROM material. Read more
Published 4 months ago by -- Peggy

5.0 out of 5 stars Great Book
I'm a little over a third into this book and I have learned several formula's that I can use in my job. Read more
Published 6 months ago by W. Forton

2.0 out of 5 stars Average Book, not bible
I was expecting more from a book called 'Bible'. It tells about average knowledge about Excel. For advanced users, I would advise that look for some better book and please let me... Read more
Published 6 months ago by Puneet Gaur

4.0 out of 5 stars Excel 2007
What can I say, if your hung-up on an Excel problem, the book will get you through. Lots of information, I found it easy to use, but I only use it when I run into trouble!
Published 7 months ago by Jim Coppage

4.0 out of 5 stars Excel 2007
Very informative. It does skip a little going from one subject to another and back to it later. Not recommended for beginners.
Published 8 months ago by Jeffrey V. Wade

5.0 out of 5 stars invaluable resource
Anyone upgrading to Excel 2007 will find this a must read for navigating new features
Published 9 months ago by Dennis A. Joyce

5.0 out of 5 stars Excel 2007
As a graduate student I was struggling with trying to use Excel 2003 directions in Excel 2007 program. Read more
Published 9 months ago by Beth A. Schrack

Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Discussion Replies Latest Post
Textbooks for Kindle DX? 61 2 days ago
textbook scam 66 7 days ago
Amazon is a great place to buy textbooks! 35 19 days ago
Search Customer Discussions
Search all Amazon discussions
   




Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Look for Similar Items by Subject

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.