Programming Books C Java PHP Python Learn more Browse Programming Books
Excel 2010 Power Programming with VBA and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $49.99
  • Save: $29.74 (59%)
Rented from apex_media
To Rent, select Shipping State from options above
Due Date: Dec 20, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
Qty:1
  • List Price: $49.99
  • Save: $22.89 (46%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $13.52
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Excel 2010 Power Programming with VBA Paperback – May 10, 2010

ISBN-13: 978-0470475355 ISBN-10: 0470475358 Edition: 1st

Buy New
Price: $27.10
Rent
Price: $20.25
53 New from $25.91 43 Used from $20.93
Rent from Amazon Price New from Used from
eTextbook
"Please retry"
Paperback
"Please retry"
$20.25
$27.10
$25.91 $20.93

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

Excel 2010 Power Programming with VBA + Excel 2010 Bible + Excel 2010 Formulas
Price for all three: $82.75

Buy the selected items together
  • Excel 2010 Bible $25.92
  • Excel 2010 Formulas $29.73

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 1080 pages
  • Publisher: Wiley; 1 edition (May 10, 2010)
  • Language: English
  • ISBN-10: 0470475358
  • ISBN-13: 978-0470475355
  • Product Dimensions: 9.3 x 7.4 x 2.2 inches
  • Shipping Weight: 3.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (116 customer reviews)
  • Amazon Best Sellers Rank: #5,602 in Books (See Top 100 in Books)

Editorial Reviews

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.

More About the Author

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the world's foremost authority on Microsoft Excel. His fifty-plus Excel books include Excel 2013 Power Programming with VBA, Excel 2013 Formulas, and the bestselling Excel 2013 Bible, all published by Wiley. He has also written hundreds of articles and software reviews, and created the award-winning Power Utility Pak add-in for Excel.

John lives in Tucson, Arizona. He also plays the banjo - but don't let that prevent you from buying his books.

Customer Reviews

Very informative well written book.
Sam
The CD that it comes with has all the examples and those are great to work with to have some boilerplate code to build from.
B. Clark
I would highly recommend this book to anyone looking to learn how to use VBA.
Johnny

Most Helpful Customer Reviews

77 of 79 people found the following review helpful By 1000Books on July 30, 2010
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.
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
48 of 49 people found the following review helpful By Sigthor on September 30, 2012
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.
14 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
35 of 37 people found the following review helpful By Glenn on November 22, 2010
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
19 of 19 people found the following review helpful By Jean L. Scalzo on December 19, 2010
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
14 of 15 people found the following review helpful By Wade T Mackey on April 20, 2012
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.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Johnny on January 22, 2012
Format: Paperback Verified Purchase
I had used VBA for Excel before, but it was quite informal and I only learned through studying other VBA programs. So I wasn't exactly a beginner, but I wanted a book to help me brush up on my abilities and serve as a reference in the future. Excel 2010 Power Programming with VBA was a perfect fit. Includes plenty of example files that are useful not only for demonstration, but also for borrowing some techniques and ideas for your own needs. I would highly recommend this book to anyone looking to learn how to use VBA. At less than $30 and nearly a thousand pages of quality instruction and examples, it's hard to find a better value.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
12 of 14 people found the following review helpful By J. Yoon on October 27, 2011
Format: Paperback Verified Purchase
I have the Office 2007 software, but this book is very applicable. Book provides a comprehensive introduction to the ribbon interface. VBA is very well explained. I had a hard time learning VBA 15 years ago on my own because I could not see the overall structure of the program. Now this book makes it so much easier. I wish a book like this existed back then. It has a lot of pages, but they go by quickly. If you know a little bit about programming in any language, I think this book makes EXCEL/VBA easy to learn. Best of all, the 2010 paperback version includes an eBook in the enclosed CD. So you can have a copy in your iPad for when you don't want to lug the large book around. VBA in a Nutshell is probably a good companion reference for looking up all VBA commands in all office applications, such a Word or Outlook.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search

What Other Items Do Customers Buy After Viewing This Item?