Excel 2013 Power Programming with VBA 1st Edition

by John Walkenbach (Author)

140 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 $4.31
Gift Card.

Trade in
Learn More

Have one to sell? Sell on Amazon

Share <Embed>

Due Date: Dec 19, 2018 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: $28.49 (57%)

Free Shipping

Add to Rental Cart

In Stock.

Ships from and sold by Amazon.com exclusively for Prime members. Gift-wrap available.

Exclusively for Prime members

This item is reserved for Prime members. Details

Amazon Students get 50% off on a Prime membership Learn more

Price

New from

Used from

Kindle

"Please retry"

$21.13

—

Paperback

"Please retry"

$22.24

$12.28

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 2013 Formulas

ISBN-13: 978-1118490440

$15.79
Related Text

Excel Dashboards and Reports

ISBN-13: 978-1118490426

$29.01
Related Text

Microsoft Business Intelligence Tools ...

ISBN-13: 978-1118821527

$30.22
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
Related Text

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

ISBN-13: 978-1118902684

$28.14

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

158

Paperback
$37.22
John Walkenbach

58

Paperback
$15.79
John Walkenbach

234

in Microsoft VBA
Paperback
$20.01
Bill Jelen

32

Paperback
$29.99
Matthew MacDonald

41

Paperback
$26.70
John Walkenbach

89

Paperback
$22.48

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

31

Paperback
$31.35
John Walkenbach

234

in Microsoft VBA
Paperback
$20.01
John Walkenbach

89

Paperback
$22.48
John Walkenbach

158

Paperback
$37.22
Richard Mansfield

15

in ActiveX Programming
Paperback
$28.21
John Walkenbach

58

Paperback
$15.79

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: 140 customer reviews
Amazon Best Sellers Rank: #23,894 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
- #8 in Books > Computers & Technology > Software > Microsoft > Microsoft Office

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 140 customer reviews

Rated by customers interested in

Office

4.6 out of 5 stars

Programming

4.5 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.

32 people found this helpful

Helpful

Not Helpful

Comment

Nick Rinz

Great for VBA Newcomers

May 10, 2018

Format: PaperbackVerified Purchase

Excel 2013 Power Programming with VBA
I got this for a VBA coding class a couple years ago and let me tell you that both this and the Excel 2013 Bible, link below, saved my grade that semester. It really helped me understand how to use VBA for various applications and went through step by step on how to code. I am not a coder and by the end of the semester I was writing hundreds of lines of code for not only the class but for my own personal use. Would absolutely recommend for any novice in excel VBA.

Excel Bible
Excel 2013 Bible

I am part of the Amazon Associates Program

Helpful

Not Helpful

Comment

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.

3 people found this helpful

Helpful

Not Helpful

Comment

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.

6 people found this helpful

Helpful

Not Helpful

Comment

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.

6 people found this helpful

Helpful

Not Helpful

Comment

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.

2 people found this helpful

Helpful

Not Helpful

Comment

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.

42 people found this helpful

Helpful

Not Helpful

Comment

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.

One person found this helpful

Helpful

Not Helpful

Comment

Customer images

See all customer images

Most recent customer reviews

Amazon Customer

Very Good and Easy Read

This book is very comprehensive. He takes you through all the basics, and explains things in great detail. Contrary to what some people have said, his coding DOES work!Read more

Published 1 month ago

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 2 months 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 3 months ago

H.C.B.

Five Stars

Received the book in very very good condition! Thanks.

Published 3 months 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 6 months ago

Amazon Customer

Four Stars

nice book

Published 8 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 8 months ago

Mora

Five Stars

thank you

Published 11 months ago

hugh@jago.to

Five Stars

As Advertised

Published 11 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 12 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: 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

This item, sold by Amazon.com, is currently reserved exclusively for Prime members.

Exclusively for Prime members

Related materials

Customers who bought this item also bought

Customers who viewed this item also viewed

Editorial Reviews

From the Back Cover

About the Author

Product details

Customer Reviews

Read reviews that mention

Top customer reviews

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

Customer images

Most recent customer reviews

Set up an Amazon Giveaway

What other items do customers buy after viewing this item?

Excel 2013 Power Programming with VBA 1st Edition

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

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

This item, sold by Amazon.com, is currently reserved exclusively for Prime members.

Exclusively for Prime members

Related materials

Customers who bought this item also bought

Customers who viewed this item also viewed

Editorial Reviews

From the Back Cover

About the Author

Product details

Customer Reviews

Read reviews that mention

Top customer reviews

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

Customer images

Most recent customer reviews

Set up an Amazon Giveaway

What other items do customers buy after viewing this item?

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

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

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

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