Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Excel 2007 Formulas (Mr. Spreadsheet's Bookshelf)

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

John Walkenbach
4.2 out of 5 stars  See all reviews (16 customer reviews)

Print List Price: £29.99
Kindle Price: £21.84 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £8.15 (27%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition £21.84  
Paperback £29.99  
Unknown Binding --  
Kindle Daily Deal
Kindle Daily Deal: At least 60% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Special Offers and Product Promotions

  • Between 20-26 October 2014, spend £10 in a single order on item(s) dispatched from and sold by and receive a £2 promotional code to spend in the Amazon Appstore. Here's how (terms and conditions apply)

Product Description

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 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

*NOTE - Kindle edition does not include CD.

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

Product details

  • Format: Kindle Edition
  • File Size: 33987 KB
  • Print Length: 840 pages
  • Publisher: Wiley; 1 edition (31 Dec 2008)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (16 customer reviews)
  • Amazon Bestsellers Rank: #515,874 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Author

John Walkenbach, principal of J-Walk and Associates Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books and 300 articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at, which gets thousands of visitors each month.

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

Most Helpful Customer Reviews
6 of 6 people found the following review helpful
4.0 out of 5 stars Excel Formulas 1 Mar 2011
Format:Paperback|Verified Purchase
The book a decent book to give you a good overveiw of Excel formulas. I think it could potentially be a little easier to follow and would benefit from more examples. I don't think it does the IF formula justice, doesn't really have much on it, which surprised me. The book is not really for beginners, but if you have a decent understanding you will learn more tricks, which will aid your spreadsheet design.
Comment | 
Was this review helpful to you?
23 of 25 people found the following review helpful
5.0 out of 5 stars A well structured book that gives solutions 26 Oct 2007
I first bought this book when I was having difficulty with some very large excel spreadsheets and wanted to treat them as arrays. The book answered my questions. I have since bought the book whilst at several companies and regard it as essential in my work. It has chapters on various topics and I can find advanced features quickly and easily, whereas I haven't been able to do that with on-line help.
An excellent book for anyone that uses Excel heavily.
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
5.0 out of 5 stars Excel 2007 Formulas (Mr. Spreadsheets Bookshelf) 24 Dec 2009
This book is excellent for those who want to master excel formulas for version 2007. I found this book very useful and the author has covered every single aspect of calculations using excel. Excellent approach.
Comment | 
Was this review helpful to you?
8 of 9 people found the following review helpful
5.0 out of 5 stars A must Have 18 May 2009
By R. Mead
This was the first "user guide" that I have actually managed to read the whole way through.

Easy to get to grips with and gradually builds levels of complexity, I strongly recommend this for the mid-level user wanting to get more out of excel.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Everything you want to do with Excel 2007 27 Aug 2012
Format:Paperback|Verified Purchase
This is my Excel Bible now. I'm now MUCH MORE confident that I will be able to find any forumulas with Excel. Thumbs up.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Extremely good. 1 Jun 2011
By The Emperor TOP 1000 REVIEWER
Format:Paperback|Verified Purchase
I found this book to be very useful and it pretty much did everything that I expected of it. The CD that it came was also extremely useful and accurate.

The book was well written and easy to understand. Some of the more advanced stuff was brilliantly useful and it certainly goes far beyond what you can get from the help function in excel.

It does cover some basic areas that I didn't really need as I also have the excel bible from the same author but it does mean that if you are quite comfortable in excel then you only need to buy this book.

Like a lot of books from this publisher it does have a slightly cheap feel to it and I didn't like the grey colour of the text but that is only a minor quibble.
Was this review helpful to you?
5.0 out of 5 stars Really good 23 Jun 2014
By Saab
Format:Paperback|Verified Purchase
Really good book and some really useful tips and great formulas that are going to save me a heap of time
Comment | 
Was this review helpful to you?
5.0 out of 5 stars An Excel-lent Bible 2 May 2014
By T. Tran
Format:Paperback|Verified Purchase
An Analyst by profession, this manual is beyond useful. It has greatly increased my knowledge from what I already knew. Full of tricks of the trade that is so easy to understand and learn. Well for me anyhow. To be fair, the knowledge contained therein would only be advantageous for those people who have some prior knowledge/experience of Excel.

How has it benefited me? For home: I've a much better understanding of my household budget, energy usage and billing, and mortgage projections. For work: developed new analytical tooling, development of new reporting constructs all to better Operations and Strategic development.

Knowledge is empowerment!
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Most Recent Customer Reviews
3.0 out of 5 stars Used it once
I used this once and from then on I used the excel online help. However, it is comprehensive of information and a good book. I just personally prefer the online help!
Published 13 months ago by Silviaso
5.0 out of 5 stars Must buy!!!!!!!
This book is definately worth it's weight in gold, for an intermediate user in excel I find it easy to read and it definately highlights the new functions with excel 2007, plus... Read more
Published 19 months ago by Osun7amig
5.0 out of 5 stars positive
I bought this book for my friend for his birthday. He loved it and was really thankful. Cant say much as I have not read it myself, however my friend was really pleased with it.
Published 19 months ago by Aziz
5.0 out of 5 stars Excel 2007
Very useful and well explained. I would recommend it to anyone who wants to learn basic and more difficult function on excel.
Published 21 months ago by Peter Cooper
5.0 out of 5 stars An extremely useful tool for working
This book is very rich in terms of variety of issues explained and approaches to the main Excel problems that an intermediate user faces during working routines. Read more
Published 23 months ago by Angelica
2.0 out of 5 stars I'm afraid I'm not a fan of John's writing style!
The content is pretty basic in my opinion, once you've spent a few years in the Excel trenches anyway. The one overwhelming problem I have with the Mr. Read more
Published on 2 Dec 2011 by SupremeDalek
1.0 out of 5 stars incomplete order
my book arrived without the promised CD ( soft copy of the book) . So instead of the soft copy i have to manage with the thick fat book all the time ...
Published on 28 Nov 2010 by rashi
3.0 out of 5 stars Formula Bible
A must have for any data analyst that uses Excel extensively. Well laid out and clearly explained, provides PDF copy to read on the go.
Published on 8 Aug 2010 by PointP
Search Customer Reviews
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
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category