| | |  | | Home » Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) | | | | | | | Product Promotions: | | | | | Description: | | All the methods and tools you need to successfully program with ExcelJohn 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. | | | Product Details: | | | Author:
| John Walkenbach | | Paperback:
| 1080 pages | | Publisher:
| Wiley | | Publication Date:
| May 10, 2010 | | Language:
| English | | ISBN:
| 0470475358 | | Product Length:
| 9.26 inches | | Product Width:
| 7.36 inches | | Product Height:
| 2.25 inches | | Product Weight:
| 3.43 pounds | | Package Length:
| 9.2 inches | | Package Width:
| 7.4 inches | | Package Height:
| 2.4 inches | | Package Weight:
| 3.55 pounds | | Average Customer Rating:
|  based on 23 reviews |
| | | | Used and New: | | | |
| All | |
| $21.00 | Used
- Good | | | $21.00 | Used
- Good | | | $21.00 | Used
- Mint | | | $21.99 | Used
- Good | | | $24.94 | New | | | $24.94 | New | | | $24.94 | New | | | $24.94 | New | | | $24.94 | New | | | $24.94 | New | | | $25.77 This item ships for FREE with Super Saver Shipping. | Used
- Acceptable | | | $25.97 | Used
- Mint | | | $25.97 | Used
- Mint | | | $25.97 | Used
- Mint | | | $26.00 | Used
- VeryGood | | | $26.00 | Used
- VeryGood | | | $26.47 | New | | | $26.53 | New | | | $26.56 | New | | | $27.26 This item ships for FREE with Super Saver Shipping. | Used
- Acceptable | | | $28.45 | Used
- Good | | | $28.47 | Used
- VeryGood | | | $28.95 This item ships for FREE with Super Saver Shipping. | New | | | $28.95 | New | | | $28.99 | Used
- Good | | | $29.00 | New | | | $29.00 | Used
- VeryGood | | | $29.13 | Used
- Good | | | $29.44 | Used
- Mint | | | $29.44 | New | | | $29.99 | Used
- Mint | | | $30.00 | Used
- VeryGood | | | $31.54 | Used
- Mint | | | $32.49 | Used
- Mint | | | $34.99 | New | | | $35.32 | Used
- Mint | | | $35.32 | New | | | $35.52 | New | | | $36.41 | New | | | $37.11 | New | | | $37.11 | Used
- Mint | | | $37.47 | Used
- Mint | | | $37.49 | New | | | $38.37 | New | | | $38.56 | New | | | $38.88 | New | | | $39.49 | New | | | $39.99 | New | | | $40.15 | New | | | $41.54 | New | | | $41.54 | Used
- Mint | | | $42.51 | New | | | $42.53 | Used
- VeryGood | | | $42.56 | New | | | $42.70 | New | | | $43.87 | New | | | $44.55 | New | | | $45.98 | New | | | $46.68 | New | | | $47.09 | Used
- Mint | | | $47.11 | New | | | $48.00 | New | | | $49.44 | New | | | $49.52 | Used
- Good | | | $49.57 | New | | | $49.99 | New | | | $49.99 | New | | | $50.11 | New | | | $52.13 | New | | | $54.47 | Used
- VeryGood | | | $56.00 | Used
- Acceptable | | | $59.16 | New | | | $59.22 | New | | | $59.75 | New | | | $59.99 | New | | | $67.78 | New | | | $69.29 | Used
- VeryGood | | | $69.37 | Used
- Mint | | | $69.91 | Used
- Mint | | | $70.79 | New | | | $75.65 | New | | | $76.97 | New | | | $83.62 | New | |
| New | |
| $24.94 | New | | | $24.94 | New | | | $24.94 | New | | | $24.94 | New | | | $24.94 | New | | | $24.94 | New | | | $26.47 | New | | | $26.53 | New | | | $26.56 | New | | | $28.95 This item ships for FREE with Super Saver Shipping. | New | | | $28.95 | New | | | $29.00 | New | | | $29.44 | New | | | $34.99 | New | | | $35.32 | New | | | $35.52 | New | | | $36.41 | New | | | $37.11 | New | | | $37.49 | New | | | $38.37 | New | | | $38.56 | New | | | $38.88 | New | | | $39.49 | New | | | $39.99 | New | | | $40.15 | New | | | $41.54 | New | | | $42.51 | New | | | $42.56 | New | | | $42.70 | New | | | $43.87 | New | | | $44.55 | New | | | $45.98 | New | | | $46.68 | New | | | $47.11 | New | | | $48.00 | New | | | $49.44 | New | | | $49.57 | New | | | $49.99 | New | | | $49.99 | New | | | $50.11 | New | | | $52.13 | New | | | $59.16 | New | | | $59.22 | New | | | $59.75 | New | | | $59.99 | New | | | $67.78 | New | | | $70.79 | New | | | $75.65 | New | | | $76.97 | New | | | $83.62 | New | |
| Used | |
| $21.00 | Used
- Good | | | $21.00 | Used
- Good | | | $21.00 | Used
- Mint | | | $21.99 | Used
- Good | | | $25.77 This item ships for FREE with Super Saver Shipping. | Used
- Acceptable | | | $25.97 | Used
- Mint | | | $25.97 | Used
- Mint | | | $25.97 | Used
- Mint | | | $26.00 | Used
- VeryGood | | | $26.00 | Used
- VeryGood | | | $27.26 This item ships for FREE with Super Saver Shipping. | Used
- Acceptable | | | $28.45 | Used
- Good | | | $28.47 | Used
- VeryGood | | | $28.99 | Used
- Good | | | $29.00 | Used
- VeryGood | | | $29.13 | Used
- Good | | | $29.44 | Used
- Mint | | | $29.99 | Used
- Mint | | | $30.00 | Used
- VeryGood | | | $31.54 | Used
- Mint | | | $32.49 | Used
- Mint | | | $35.32 | Used
- Mint | | | $37.11 | Used
- Mint | | | $37.47 | Used
- Mint | | | $41.54 | Used
- Mint | | | $42.53 | Used
- VeryGood | | | $47.09 | Used
- Mint | | | $49.52 | Used
- Good | | | $54.47 | Used
- VeryGood | | | $56.00 | Used
- Acceptable | | | $69.29 | Used
- VeryGood | | | $69.37 | Used
- Mint | | | $69.91 | Used
- Mint | |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 23 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
41 of 42 found the following review helpful:
 Great for people who are not quite beginners not quite expertsJul 31, 2010
By 1000Books
"1000Books"
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.
18 of 19 found the following review helpful:
Great book to learn Excel VBANov 23, 2010
By Glenn
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.
8 of 8 found the following review helpful:
Informs well, Instructs even better.Dec 19, 2010
By Jean L. Scalzo
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.
6 of 6 found the following review helpful:
 E-BookDec 27, 2011
By Gene
Excellent E-book to learn Excel VBA programming! Author is extremely knowledgeable about the subject. Only 2 issues I have some of the images are unreadable and the Publisher does not have the CD content available for download.
3 of 3 found the following review helpful:
Great on Ribbon and VBA programmingOct 28, 2011
By J. Yoon
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.
See all 23 customer reviews on Amazon.com
| | |
|
