Start reading Excel 2010 Power Programming with VBA on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

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 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
 
 

Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) [Kindle Edition]

John Walkenbach
3.9 out of 5 stars  See all reviews (18 customer reviews)

Print List Price: £33.99
Kindle Price: £21.01 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £12.98 (38%)
* Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition £21.01  
Paperback £23.11  
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

  • Purchase any Kindle Book sold by Amazon.co.uk and receive £1 credit to try out our Digital Music Store. Here's how (terms and conditions apply)

Customers Who Bought This Item Also Bought


Product Description

Product Description

All the methods and tools you need to successfully program with Excel

John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.

Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA.

  • Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA)
  • Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications
  • Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won’t find anywhere else
  • Includes a CD with templates and worksheets from the book

This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

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

From the Back Cover

Get more from Excel—learn to extend it with VBA Learn to use Visual Basic for Applications (VBA), and you can expand the already awesome power of Excel 2010. John Walkenbach, aka Mr. Spreadsheet, shows you how to do it in this easy–to–follow guide. If you′re already an experienced Excel user, this book will make you an Excel master. You′ll learn a new approach to Excel and the steps involved in developing a new spreadsheet application. You′ll also discover how to develop VBA subroutines and functions, use advanced programming techniques, and more. And if you′re switching to Excel 2010 from an earlier version, there′s a section to get you up to speed on the new features. No one can teach you more about Excel than Mr. Spreadsheet. Let Mr. Spreadsheet show you how to: Create powerful Excel apps with VBA Develop user–friendly dialog boxes Enhance Excel with custom worksheet functions Write event–driven VBA code CD–ROM INCLUDES: More than 300 files used as examples in the book Searchable PDF of the book See Appendix D for complete system requirements

Product details

  • Format: Kindle Edition
  • File Size: 7048 KB
  • Print Length: 1080 pages
  • Publisher: Wiley; 1 edition (15 April 2010)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B005ZIPQK6
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 3.9 out of 5 stars  See all reviews (18 customer reviews)
  • Amazon Bestsellers Rank: #71,728 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 www.j-walk.com/ss, which gets thousands of visitors each month.

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

Most Helpful Customer Reviews
36 of 36 people found the following review helpful
Format:Paperback|Verified Purchase
This really is an excellent book for those wishing to develop Excel applications. It provides clear and useful information on the workings of Excel spreadsheets and how to interact/control them in VBA. Although I have over 12 years of Access VBA experience, my Excel abilities are far less robust. This book really does cover most of the bases: beginners will be pleased to know that there is a good introduction to the basics of VBA in early chapters, whilst more experienced developers will find a multitude of hints and tips to improve their applications. Topics include VBA fundamentals, the structure of Excel files, User forms, Object Oriented coding, coding charts and pivots, integrating with other Office apps, including help files and much more.

There is a nice glossary of VBA commands and functions in the back with one line explanations which you can then take further by looking up the details via the index, and it comes with a CD of code samples.

Is it perfect? No. There is very little on interfacing Excel to external data sources using MS Query for example, and only 1 page on considerations when making the application cross platform with Mac Excel (although Office 2011 for Mac with VBA support has only just been released, Office 2004 for Mac does have VBA too, so a little more would have been nice. Not all Mac users use Office 2008).
Comment | 
Was this review helpful to you?
6 of 7 people found the following review helpful
5.0 out of 5 stars Great reference book for Excel VBA 13 Nov 2011
By Lilly8
Format:Paperback
As someone who is self-taught and regularly programmes in Excel VBA, I was looking for a reference book for Excel 2010. While a lot of the content is familiar, it is always useful to look at how other people tackle a problem and it will change how I approach things in future.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
4.0 out of 5 stars Excellent Book 4 Jan 2014
By Archer
Format:Paperback|Verified Purchase
I have got a number of John Walkenbach's books on Excel programming starting from Excel 97. Always clear and informative and even though I have been programming for a number of years, I still come across nuggets of golden information in his books.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
4.0 out of 5 stars Simple and Direct 21 Aug 2013
By Biscaia
Format:Paperback|Verified Purchase
This book is a direct way to learn advanced excel tools. A nice complement skill to support any management job.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars An excel book by John Walkenbach.... 14 Mar 2013
By Alan D.
Format:Paperback|Verified Purchase
What else is there to say - an excellent volume which I use as a reference for Programming with VBA
Comment | 
Was this review helpful to you?
Format:Paperback|Verified Purchase
This is a great book with some very advanced VBA programming techniques for Excel. I've certainly learned a lot from it, very useful!

If you're thinking of getting the Kindle version, don't bother - all of the examples are on the cd and some of the projects are ONLY on the cd. You also get a PDF of the ebook on the CD which you can easily convert to a (better formatted) kindle ebook anyway.
Comment | 
Was this review helpful to you?
15 of 20 people found the following review helpful
By KayCee
Format:Kindle Edition|Verified Purchase
Only gave this 1 star because of the formatting for the eBook version - it's abysmal! This is the most poorly formatted book I've ever bought. Programming code is all left-aligned, with no indents; images are tiny, and left-aligned; normal paragraphs break halfway through a line, or even after a couple words; bulleted lists are unreadable throughout. Constant references are made to a CD ROM where you can find resources, but there's no downloadable version of the contents.

Nobody from the publishers Wiley can have sat down and proofed this eBook. How they can get away with charging £18 for formatting this bad is beyond me. Which is a pity because the author obviously knows his stuff. Buy it in printed format, but leave the eBook version alone.
Was this review helpful to you?
Format:Paperback|Verified Purchase
If you're seriously looking at this product, you're probably the type of person who is a wizard in some weird fantasy role playing game so why not become a more powerful spreadsheet wizard too! This will give you +5 excel knowledge.

I would say this is very good for someone who already has a good working knowledge of excel but is a vba beginner. Very handy when using the general knowledge provided in this book in conjunction with specific examples of code found on many vba forums online.
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
2.0 out of 5 stars kindle version down fall
The content appears very well written, however as mentioned by others the formatting of the code is not indented which makes it difficult to read. Read more
Published 4 months ago by Amazon Customer
5.0 out of 5 stars getting to grips with VBA
Excellent value. Great description - author knows his stuff and is good at communicating it. It would be helpful to have a point by point outline of how to accomplish things on... Read more
Published 7 months ago by Brian
5.0 out of 5 stars Excelent
John Walkenbach's books are always a good read/easy and ready resource. I would recommend this for anyone wanting to upgrade their skills.
Published 7 months ago by Kevin Cole
4.0 out of 5 stars Great Book Lots of information!
Wonderful book, so much information.
The only downside is there's obviously no CD, some programming examples are only on CD.
Published 13 months ago by Robert Stevens
3.0 out of 5 stars Excel VBA
Disappointing not to get the VBA examples that are provided with the paperback version of the book. Otherwise it is OK
Published 15 months ago by John Coatman
5.0 out of 5 stars Clear guidance on VBA
I have used John Walkenbach's books before in paper form. When looking for an update from the 2003 version of the book I chose a Kindle version. I was not disappointed. Read more
Published 16 months ago by davidup
1.0 out of 5 stars Useless
The most important element of this book is the CD, which I did not get with my order.Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
Published 17 months ago by Mr. S. A. Chatt
4.0 out of 5 stars Good learning material
As a newbie to programing I thought reading some useful correctly written vba would be helpful working from examples working from examples from this book very good content.
Published 17 months ago by steve
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
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category