Excel 2010 Power Programming with VBA and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
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 download a FREE Kindle Reading App.

Excel 2010 Power Programming with VBA [Paperback]

John Walkenbach
4.8 out of 5 stars  See all reviews (4 customer reviews)
List Price: CDN$ 59.99
Price: CDN$ 37.61 & FREE Shipping. Details
You Save: CDN$ 22.38 (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
In Stock.
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Monday, April 21? Choose One-Day Shipping at checkout.

Formats

Amazon Price New from Used from
Kindle Edition CDN $30.12  
Paperback CDN $37.61  
There is a newer edition of this item:
Excel 2013 Power Programming with VBA Excel 2013 Power Programming with VBA 4.0 out of 5 stars (1)
CDN$ 37.61
Usually ships in 2 to 5 weeks

Book Description

May 10 2010 Mr. Spreadsheet's Bookshelf (Book 6)
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.


Frequently Bought Together

Excel 2010 Power Programming with VBA + Excel 2010 Bible + Excel 2010 Formulas
Price For All Three: CDN$ 101.46

Show availability and shipping details

  • In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping. Details

  • Excel 2010 Bible CDN$ 33.85

    In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping. Details

  • Excel 2010 Formulas CDN$ 30.00

    In Stock.
    Ships from and sold by Amazon.ca.
    FREE Shipping. Details


Customers Who Bought This Item Also Bought


Product Details


Product Description

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

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 50-plus books include John Walkenbach's Favorite Excel 2010 Tips & Tricks, Excel 2010 Formulas, and the bestselling Excel Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

3 star
0
2 star
0
1 star
0
4.8 out of 5 stars
4.8 out of 5 stars
Most helpful customer reviews
2 of 2 people found the following review helpful
By Ed
Format:Paperback|Verified Purchase
As a 30-year user and developer of thousands of spreadsheets, I was surprised at the amount of new and basic information I learned about MS Excel. I bought the book for some VBA insights and tips but ended up with much more. It does assume some basic knowledge and experience with MS Excel but is very well written, cross indexed, and supported with the included CD. I highly recommend the book for those who want to do more with MS Excel, and especially those who want to develop MS Excel-based applications.
Was this review helpful to you?
2 of 3 people found the following review helpful
5.0 out of 5 stars The best Excel Books Dec 15 2011
By Joe
Format:Paperback
I own two other John Walkenbach Excel books and he never fails to deliver. I spent 2 yrs. at my last job building applications with VBA in Excel. John's books were indispensible. He made me look like a genius and trust me I'm not.
Was this review helpful to you?
5.0 out of 5 stars Excel 2010 Power Programming Aug. 3 2011
Format:Paperback
This is my second book purchase in John Walkenbach's VBA series, the first being Power Programming for Excel 2002. Like its predecessor, this book is clearly written with many helpful examples and is an excellent way to learn the ins and outs of VBA programming. I highly recommend it to all.
James Kelsh, CGA, CertIFR
Was this review helpful to you?
0 of 1 people found the following review helpful
4.0 out of 5 stars Excel 2010 Power Programming with VBA Aug. 20 2013
Format:Kindle Edition|Verified Purchase
The book is very well written and the concepts of Excel and VBA merged is presented in a clear very clear manner. The E-book format however could be much improved as it is quite cumbersome to navigate through the book when one needs to go back and forth to revisit previously read pages. It would help if there were page numbers and a search function.
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.2 out of 5 stars  104 reviews
76 of 78 people found the following review helpful
5.0 out of 5 stars Great for people who are not quite beginners not quite experts July 30 2010
By 1000Books - Published on Amazon.com
Format:Paperback|Verified Purchase
While everyone's starting to learn cooler hipper languages, the reality is that VBA in excel is still pretty darn useful.

If you have absolutely no experience then VBA for dummies is still - to me - one of the better places to start. The book is not as big and intimidating. However, after you've already written a few programs, this book is fantastic. Great step by step instructions. Lots of examples. Advanced sections are great. It will take me some time before this all becomes old hat for me.

If you were looking for something that uses VBA to link to other Microsoft applications. You should be good with this book. It goes into detail on how to interface with outlook, deal with sending emails, interface with Word or PowerPoint.

If you need to learn how to interface with databases, this is not the best choice. But there is no reason to believe it would be in the title or table of contents, so you really can't complain.

Will it replace the all mighty google. No, but as a supplement, it is excellent and a bit more structured. The explanations are far better than what you'd find on-line. There are tons of random helpful tips and history that - if you're nerdy enough to read the whole book rather than just use the table of contents and index to get to the sections you need - are pretty darn wonderful.

Oh, and for people who can't stand the upgrades in the new version of Excel, the author explains that stuff too. One reason to get the newer vs the older version.
42 of 43 people found the following review helpful
2.0 out of 5 stars Do not buy Kindle version Sept. 30 2012
By Sigthor - Published on Amazon.com
Format:Kindle Edition|Verified Purchase
I find the book very informative and useful and I feel cheated on

I sadly bought the Kindle version and I feel ripped off, First I pay 4 dollars more for the Kindle version even if that meant me not getting the CD or other side products. I could live with that, at least I got the book right....

But no, the examples in this book are useless as it is not possible to zoom the images with Kindle and most formuals that Spreadsheet goes over are based on those images.

I had before bought the book "Excel The missing Manual" and that was great on Kindle and it was even cheaper for Kindle,
but adding 4 dollars for Kindle version without any side products and horrible quality is a rip off, and Mr. Spreadseet and Amazon should really do something to fix this. Its amazing disrespect to customers. I cant see my self buy a book by Mr. Spreadsheet again or even Amazon just because of this incident, I'll stick to other authors that at least have the decency to not publish books for Kindle version if they cant provide the same quality as the book.

It is incredibly frustrating and i feel so ripped off, you can not see this flaw in the preview so I feel cheated on.

Sad as the book is so good.
34 of 36 people found the following review helpful
5.0 out of 5 stars Great book to learn Excel VBA Nov. 22 2010
By Glenn - Published on Amazon.com
Format:Paperback|Verified Purchase
I tried the Bill Jelen "VBA and Macros" book first but got too frustrated with it. Too much was left "un-said" in that book. So, even though I was forcing myself to learn from it, I decided to get this book too.

WOW! John Walkenbach does a great job of starting at the beginning, giving a very interesting spreadsheet background, and then quickly and concisely plunging you into the VBA world. I have also picked up a lot of non-VBA great Excel tips that I have started using.

Keep in mind, this book still isn't for the timid. It is serious learning and you have to be prepared to learn quick. But, I feel the book does a great job of teaching with just the right amount of detail. It also helps if you think very logical and sequential. If you can't organize your thoughts, you won't be able to program very well.
18 of 18 people found the following review helpful
5.0 out of 5 stars Informs well, Instructs even better. Dec 19 2010
By Jean L. Scalzo - Published on Amazon.com
Format:Paperback|Verified Purchase
I was surprised at the quality of the instruction in this book. It seems to be much more informative of Excel's features than books I have read for prior versions of Excel. I always have considered myself an expert in Excel. This book has shown me wrong. There is a multitude of features and functions that I am extremely happy to see excellent instruction for.
14 of 15 people found the following review helpful
5.0 out of 5 stars Don't get the Kindle version April 20 2012
By Wade T Mackey - Published on Amazon.com
Format:Kindle Edition|Verified Purchase
The book is great. I'm getting a lot out of it. But the kindle version does not include acces to the CD content, the graphics are nearly unreadable and longer code examples on the page disapear of the right side of the screen. Broke down and ordered the physical book.
Search Customer Reviews
Only search this product's reviews
ARRAY(0xa5c5df84)

Look for similar items by category


Feedback