Excel 2013 Power Programming with VBA 1st Edition

by John Walkenbach (Author)

139 customer reviews

Related Text

ISBN-13: 978-1118490396

ISBN-10: 1118490398

Why is ISBN important?

Trade in your item
Get a $5.57
Gift Card.

Trade in
Learn More

Have one to sell? Sell on Amazon

Share <Embed>

Condition: Used - Good

In Stock. Sold by greener_books_london

Access codes and supplements are not guaranteed with used items.

In Stock.

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

List Price: $49.99 Save: $27.75 (56%)

45 New from $22.24

FREE Shipping on orders over $25—or get FREE Two-Day Shipping with Amazon Prime

Turn on 1-Click ordering

More Buying Choices

45 New from $22.24 49 Used from $13.11

94 used & new from $13.11

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.

Related materials

Page 1 of 1Start OverPage 1 of 1

Related Text

Excel Dashboards and Reports

ISBN-13: 978-1118490426

$25.28
Related Text

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

ISBN-13: 978-1118902684

$28.81
Related Text

Excel 2013 Formulas

ISBN-13: 978-1118490440

$15.79
Related Text

Microsoft Business Intelligence Tools ...

ISBN-13: 978-1118821527

$35.91
Related Text

101 Ready-To-Use Excel Macros

ISBN-13: 978-1118281215
Reference

101 Excel 2013 Tips, Tricks and Timesa...

ISBN-13: 978-1118642184

$25.75

Frequently bought together

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

156

Paperback
$22.33
John Walkenbach

57

Paperback
$15.79
Michael Alexander

76

Paperback
$25.28
John Walkenbach

229

in Microsoft VBA
Paperback
$22.53
Matthew MacDonald

40

Paperback
$32.70
Bill Jelen

31

Paperback
$29.99

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.

John Walkenbach

229

in Microsoft VBA
Paperback
$22.53
Michael Alexander

29

Paperback
$31.35
John Walkenbach

156

Paperback
$22.33
John Walkenbach

78

Paperback
$22.48
Michael Alexander

76

Paperback
$25.28
Rob Bovey

45

Paperback
$41.77

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.

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: 139 customer reviews
Amazon Best Sellers Rank: #30,366 in Books (See Top 100 in Books)
- #2 in Books > Computers & Technology > Programming > Microsoft Programming > VBA
- #2 in Books > Computers & Technology > Programming > Languages & Tools > Visual Basic
- #14 in Books > Computers & Technology > Software > Microsoft > Microsoft Excel

Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?

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.

Customer Reviews

Write a customer review

See all 139 customer reviews

Rated by customers interested in

What's this?

Computer Books

4.1 out of 5 stars

Microsoft Software Books

5.0 out of 5 stars

Sports Books

4.4 out of 5 stars

Is this feature helpful?

Thank you for your feedback.

Read reviews that mention

Top customer reviews

There was a problem filtering reviews right now. Please try again later.

R. Montgomery

A very useful guide to Visual Basic and the Excel Ecosystem

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.

Comment 31 people found this helpful. Was this review helpful to you?

Yes

GeoFam

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

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.

Comment 6 people found this helpful. Was this review helpful to you?

Yes

Rip Van Winkle

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

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.

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

Yes

Reefer

Excellent VBA reference

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.

Comment 2 people found this helpful. Was this review helpful to you?

Yes

minnesota reader

This is the gold standard.

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.

Comment 2 people found this helpful. Was this review helpful to you?

Yes

ChemProf

needed for new version of Excel

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.

Comment 42 people found this helpful. Was this review helpful to you?

Yes

deejay

Practical approach to VBA skills development

August 4, 2017

Format: Kindle EditionVerified Purchase

I have been able to teach myself enough VBA programming to significantly automate several time consuming processes.

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

Yes

TheDude

Arrived in great condition and in a timely manner

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.

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

Yes

Customer images

See all customer images

Most recent customer reviews

DIE

I would like to learn Excel VBA to be able to develop ...

Hello Sir,
I would like to learn Excel VBA to be able to develop applications. So I am planning to use this book and learn all of its content over the next 6 months.Read more

Published 4 days ago

TOM DELORGE

IF YOU COULD DUPLICATE SOMETHING LIKE EXCEL 2000 PRORA MING - SIMPLE BASIC LEARNING INSTRUCTIONS ...

NOT YOUR PROBLEM. IT JUST WASN'T WHAT I WAS LOOKING FOR. IF YOU COULD DUPLICATE SOMETHING LIKE EXCEL 2000 PRORA MING - SIMPLE BASIC LEARNING INSTRUCTIONS AT THE ONSET OF THE...Read more

Published 10 days ago

H.C.B.

Five Stars

Received the book in very very good condition! Thanks.

Published 1 month ago

M. Archer

I am enjoying the book slowing. I just hope ...

I am enjoying the book slowing. I just hope that at the end of the book, I will be able to write and interpret computer programs.

Published 3 months ago

Amazon Customer

Four Stars

nice book

Published 5 months ago

Walter Willenkin

John Walkenbach is clear and complete.

I have used his Power Programming books since I started VBA programming 20 years ago. 50,000 lines of working VBA code later ,I still find his books helpful.Read more

Published 5 months ago

Mora

Five Stars

thank you

Published 8 months ago

hugh@jago.to

Five Stars

As Advertised

Published 9 months ago

Alan Cannon

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 9 months ago

George F

Actually a good starting book on the subject.

Very detailed and well written.

Published 9 months ago

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

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