Excel 2013 Power Programming with VBA 1st Edition

by John Walkenbach (Author)

132 customer reviews

in Visual Basic Programming

Related Text

ISBN-13: 978-1118490396

ISBN-10: 1118490398

Why is ISBN important?

Trade in your item
Get a $8.61
Gift Card.

Trade in
Learn More

Have one to sell? Sell on Amazon

Share <Embed>

Due Date: Dec 18, 2017 Rental Details

FREE return shipping at the end of the semester.
Access codes and supplements are not guaranteed with rentals.

In Stock. Rented from apex_media , Fulfilled by Amazon

List Price: $49.99 Save: $30.40 (61%)

Free Shipping

Add to Rental Cart

In Stock.

Ships from and sold by Amazon.com. Gift-wrap available.

List Price: $49.99 Save: $21.57 (43%)

31 New from $24.31

FREE Shipping.

Turn on 1-Click ordering

Ship to:

Select a shipping address:

More Buying Choices

31 New from $24.31 34 Used from $19.00 1 Rentals from $19.59

66 offers from $19.00

See All Buying Options

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

Maximize your Excel 2013 experience using VBA application development

The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. 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 latest features of Excel 2013, 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 VBA
Features invaluable advice from "Mr. Spreadsheet" himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small
Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills
Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else

Excel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.

Excel 2013 Power Programming with VBA

$28.42 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Related materials

Page 1 of 1Start OverPage 1 of 1

Related Text

Excel Dashboards and Reports

ISBN-13: 978-1118490426

$24.83
Related Text

Microsoft Business Intelligence Tools ...

ISBN-13: 978-1118821527

$22.30
Related Text

101 Ready-To-Use Excel Macros

ISBN-13: 978-1118281215
Related Text

101 Ready-to-Use Excel Formulas (Mr. S...

ISBN-13: 978-1118902684

$25.75
Related Text

Excel 2013 Formulas

ISBN-13: 978-1118490440

$28.99
Reference

101 Excel 2013 Tips, Tricks and Timesa...

ISBN-13: 978-1118642184

$27.50

Frequently bought together

Total price: $80.58

Buy the selected items together

This item:Excel 2013 Power Programming with VBA by John Walkenbach Paperback $28.42
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping. Details
Excel 2013 Bible by John Walkenbach Paperback $23.17
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping on orders over $25. Details
Access 2013 Bible by Michael Alexander Paperback $28.99
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping. Details

Customers who bought this item also bought

Page 1 of 1 Start overPage 1 of 1

This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

John Walkenbach

155

Paperback
$23.17
Michael Alexander

50

Paperback
$24.83
Michael Alexander

110

Paperback
$28.99
John Walkenbach

169

in Microsoft VBA
Paperback
$21.91
John Walkenbach

55

Paperback
$28.99
Bill Jelen

30

Paperback
$35.40

Editorial Reviews

From the Back Cover

Learn to extend Excel 2013 with VBA programming

Whether your job or your curiosity impels you to learn how to develop programs that automate and enhance Excel, you'll find no better teacher than John Walkenbach. This book provides a complete introduction to Visual Basic for Applications and shows you exactly how to create the custom dialog boxes known as UserForms. Then it takes you into advanced programming techniques, such as developing utilities and using VBA to work with PivotTables and charts.

You'll also learn to create user-oriented applications, modify shortcut menus, and provide online help for your applications. If you know your way around Excel and are ready to take your skills to the next level, this book is for you.

Let Mr. Spreadsheet show you how to:

Develop VBA subroutines and functions
Create custom UserForms and dialog boxes
Use VBA to create add-ins, PivotTables, and charts
Create procedures that execute automatically when events occur
Work with class modules and color

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written 50+ books, including multiple editions of the bestselling Excel Bible and Excel Formulas, as well as more than 300 articles for publications such as PC World, InfoWorld, and Windows. He created the award-winning Power Utility Pak and provides Excel information and insight at www.spreadsheetpage.com.

NO_CONTENT_IN_FEATURE

Start reading Excel 2013 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.

Product details

Paperback: 1104 pages
Publisher: Wiley; 1 edition (April 1, 2013)
Language: English
ISBN-10: 1118490398
ISBN-13: 978-1118490396
Product Dimensions: 7.4 x 2 x 9.3 inches
Shipping Weight: 3.5 pounds (View shipping rates and policies)
Average Customer Review: 4.4 out of 5 stars See all reviews (132 customer reviews)
Amazon Best Sellers Rank: #23,107 in Books (See Top 100 in Books)
- #1 in Books > Computers & Technology > Programming > Languages & Tools > Visual Basic
- #2 in Books > Computers & Technology > Programming > Microsoft Programming > VBA
- #11 in Books > Computers & Technology > Software > Microsoft > Microsoft Excel

If you are a seller for this product, would you like to suggest updates through seller support?

Customer reviews

132

4.4 out of 5 stars

5 star		70%
4 star		12%
3 star		11%
2 star		3%
1 star		4%

Write a customer review

See all verified purchase reviews

Top customer reviews

A very useful guide to Visual Basic and the Excel Ecosystem

ByR. Montgomeryon November 23, 2014

Format: Kindle EditionVerified Purchase

This is an excellent book on three levels:
1. The book enables "New to VBA and even new to Excel" users to ramp up to proficiency quickly.
2. The book is laid out in a reference book manner so that if you need to go after a specific item you can do so quickly.
3. Despite serving as a primer at several levels, the book serves as an in depth explanation text as well; e.g. , events, user forms, etc.

0Comment 30 people found this helpful. Was this review helpful to you?YesNo

needed for new version of Excel

ByChemProfon December 27, 2013

Format: PaperbackVerified Purchase

Exceptional reference text, especially if you need to do any significant programming in VBA for scientific purposes.
This is exceptionally well written and clearly explains the changes in VBA in Excel 2013 (there are some extensive differences in the new version of Excel 2013), for which I needed a reference to help explain them (which this book does) (Please note that I use VBA a lot for my work, especially in Excel so take my statement as easy to read and explain based on my experience!)

There are numerous examples found on the book website, thus explaining the lack of CD (or DVD) that accompanied the past books in this series. Don't hesitate to partake of the offerings... it is helpful in a lot of the examples to actually see the spreadsheet being discussed while reading about it.

0Comment 41 people found this helpful. Was this review helpful to you?YesNo

reporting was becoming more and more tedious. The verbosity of the standarized reports was increasing ...

ByTomGon November 30, 2015

Format: PaperbackVerified Purchase

I encountered a situation at work where the level of daily, routine, reporting was becoming more and more tedious. The verbosity of the standarized reports was increasing every day resulting in a steady rise in typo's and incorrect formatting use. I finally had it and decided I would try to automate the reporting process.

Using this reference I was able to construct my first VBA macros and from there design and implement now daily used VBA applications that automate our processes. Using what I learned from Excel VBA I was able to dive into PowerPoint VBA which, while different, shares many similarities with Excel VBA. Our level of effort for daily reporting has dropped from three hours to less than an hour using these programs and it all started with this reference book.

Some Notes:

1) Yes, you should read each chapter at least skimming the material. I am a certified Microsoft 2013 Expert and I still found new details that I wasn't aware of during my initial read. The book covers the Excel program's features - not just the VBA aspect. Again making this a great reference for anyone looking to take advantage of all that Excel can offer.

2) I have had minimal experience as a programmer. I had eight months of C++ programming training last used 13 years ago when I was a Senior in High School. I also tried out some Java programming for a few months but never went anywhere with it. The point: Anyone can learn this as long as you put in the time to understand the material. It helps to have a program in mind and then try to build it. My first editions of my now daily used programs were terrible. They crashed all the time, had unexpected results, but I learned to handle all of these a little bit at a time.

3) Get the hard copy. You can take a hard copy with you anywhere and make notes on the pages if need be. Or place bookmarks easily. I have a reference manual on Kindle for KML Programming and I really didn't like it at all.

0Comment 5 people found this helpful. Was this review helpful to you?YesNo

Gives an insight that few other books have done foe me

ByAlan Chateron May 17, 2014

Format: Kindle EditionVerified Purchase

I would highly recommend this book to anyone looking to get to grips with those inner workings of VBA around Excel.
Examples are great and I was inspired to get right into writing my own Add-ins automating tasks that always took me hours before.
There is always so much more under the hood and John Walkenbach just as a great way to teach to a trick or two. Full Five Stars from me.
Alan Chater.

0Comment 7 people found this helpful. Was this review helpful to you?YesNo

I bought the kindle version but the parsing was horrible as this book really relies heavily on hands-on code ...

ByRip Van Winkleon August 22, 2015

Format: Kindle EditionVerified Purchase

DO NOT BUY THE KINDLE VERSION ! A must-have book for everyone who is serious about learning Excel VBA with Excel 2013. I bought the kindle version but the parsing was horrible as this book really relies heavily on hands-on code examples that translate badly to kindle format. I ended buying the old-fashioned paperback version instead. A great book.

0Comment 4 people found this helpful. Was this review helpful to you?YesNo

Excellent VBA reference

ByReeferon March 12, 2017

Format: PaperbackVerified Purchase

I have been looking for a comprehensive VBA reference and I am glad I finally found one! To put things in perspective, I consider my skills in VBA as semi-intermediate. I can follow the book very well.

0Comment One person found this helpful. Was this review helpful to you?YesNo

This is the gold standard.

Byminnesota readeron October 4, 2015

Format: Kindle EditionVerified Purchase

This is the gold standard. It's a well-written reference book. I used this in addition to some videos on YouTube to get the answers that I needed for an entry-level project. It's exactly what I need for the one-off projects that I frequently undertake.

0Comment One person found this helpful. Was this review helpful to you?YesNo

Arrived in great condition and in a timely manner

ByTheDudeon March 30, 2017

Format: PaperbackVerified Purchase

Arrived in great condition and in a timely manner! Will not teach you how to pass the exam, per se, but contains helpful practice questions.

0CommentWas this review helpful to you?YesNo

Customer images

See all customer images

Most recent customer reviews

Outstanding Value

This was a replacement copy. I had one previously, but when I retired it was misplaced when packing my office to take things home.Read more

Published 2 days ago by Alan Cannon

Actually a good starting book on the subject.

Very detailed and well written.

Published 9 days ago by George F

Three Stars

Good book, but I received it in terrible condition. Not happy.

Published 20 days ago by Andrew Vu

great for all users of VBA

it is an excellent book, as have all of J Walkenback books.

Published 21 days ago by pkparker40

Five Stars

Good book.

Published 2 months ago by Semir Taletovic

Great book!

Very thorough! Great book!

Published 2 months ago by BeatriX

Five Stars

Excellent, use it everyday at work. Learnt about VBA very quickly.

Published 3 months ago by MiddleEarth

Three Stars

Fine

Published 3 months ago by Rodd A Wilken

Like it

It is a cross between a reference book and one you can read through.

Published 4 months ago by Deborah N

Three Stars

This doesn't work on Gameboy color

Published 5 months ago by Kyle Martin Richards

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway

This item: Excel 2013 Power Programming with VBA

Set up a giveaway

Customers who viewed this item also viewed

Page 1 of 1 Start overPage 1 of 1

This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Michael Alexander

19

Paperback
$31.25
John Walkenbach

169

in Microsoft VBA
Paperback
$21.91
John Walkenbach

55

Paperback
$30.39
John Walkenbach

155

Paperback
$23.17
John Walkenbach

173

Paperback
$26.75
Michael Alexander

59

Paperback
19 offers from $42.94

Pages with related products. See and discover other items: basic programming languages, visual basic programming, visual basic for applications, visual basic, computer basic language programs, basic english

Excel 2013 Power Programming with VBA 1st Edition

Rent On clicking this link, a new layer will be open $19.59 On clicking this link, a new layer will be open

Buy new On clicking this link, a new layer will be open $28.42 On clicking this link, a new layer will be open

Turn on 1-Click ordering

or

or

Related materials

Frequently bought together

Customers who bought this item also bought

Editorial Reviews

From the Back Cover

About the Author

Product details

Customer reviews

Top customer reviews

Customer images

Most recent customer reviews

Set up an Amazon Giveaway

Customers who viewed this item also viewed

Rent On clicking this link, a new layer will be open

$19.59 On clicking this link, a new layer will be open

Buy new On clicking this link, a new layer will be open

$28.42 On clicking this link, a new layer will be open