Excel 2013 Power Programming with VBA 1st Edition

by John Walkenbach (Author)

272 ratings

Related Text

ISBN-13: 978-1118490396

ISBN-10: 9781118490396

Why is ISBN important?

Have one to sell?

Sell on Amazon

Share <Embed>

Other Sellers

from

Other Sellers

See all 6 versions

Due Date: May 27, 2021 Rental Details

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

In Stock. Rented from Amazon Warehouse , Fulfilled by Amazon

Fastest delivery: Feb 27 - March 1

List Price: $49.99
Save:$36.00(72%)

Add to Cart

Microsoft Business Intelligence... for $36.19

Excel Dashboards and Reports for $27.49

Excel 2013 Formulas for $32.05

Used: Good | Details

Sold by Murphy Sales Co.

Fulfilled by Amazon

Access codes and supplements are not guaranteed with used items.

47 used from $6.98

FREE Shipping on orders over $25.00 shipped by Amazon or get Fast, Free Shipping with Amazon Prime

Microsoft Business Intelligence... for $36.19

Excel Dashboards and Reports for $27.49

Excel 2013 Formulas for $32.05

In Stock.

Ships from and sold by Amazon.com.

Available at a lower price from other sellers that may not offer free Prime shipping.

FREE delivery: Wednesday, March 3 Details

Fastest delivery: Monday, March 1
Order within 1 hr and 33 mins Details

List Price: $49.99

Save: $14.00 (28%)

22 new from $26.00

Microsoft Business Intelligence... for $36.19

Excel Dashboards and Reports for $27.49

Excel 2013 Formulas for $32.05

Available at a lower price from other sellers that may not offer free Prime shipping.

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.

Frequently bought together

Total price: $118.03

These items are shipped from and sold by different sellers. Show details

Buy the selected items together

This item:Excel 2013 Power Programming with VBA by John Walkenbach Paperback $35.99
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping. Details
Excel 2013 Bible by John Walkenbach Paperback $49.99
Only 14 left in stock - order soon.
Ships from and sold by Amazon.com.
FREE Shipping. Details
Excel 2013 Formulas by John Walkenbach Paperback $32.05
In stock.
Ships from and sold by indoobestsellers.

Customers who viewed this item also viewed

Page 1 of 1 Start overPage 1 of 1

Michael Alexander
351
Paperback
$21.99
Michael Alexander
165
Paperback
$46.76
Michael Alexander
70
Paperback
$36.77
Bill Jelen
142
Paperback
$32.25
Michael Alexander
620
Paperback
$36.56
Richard Mansfield
70
Paperback
$47.50

Customers who bought this item also bought

Page 1 of 1 Start overPage 1 of 1

John Walkenbach
365
Paperback
$49.99
John Walkenbach
578
Paperback
$43.47
Michael Alexander
351
Paperback
$21.99
John Walkenbach
102
Paperback
$32.05
Matthew MacDonald
134
Paperback
$25.96
Bill Jelen
102
Paperback
$29.00

Special offers and product promotions

Amazon Business : For business-only pricing, quantity discounts and FREE Shipping. Register a free business account

Editorial Reviews

From the Inside Flap

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

From the Back Cover

Learn to extend Excel 2013 with VBA programming

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

ASIN : 1118490398
Publisher : Wiley; 1st edition (April 1, 2013)
Language : English
Paperback : 1104 pages
ISBN-10 : 9781118490396
ISBN-13 : 978-1118490396
Item Weight : 3.15 pounds
Dimensions : 7.4 x 2.3 x 9.2 inches

Best Sellers Rank: #193,720 in Books (See Top 100 in Books)
- #7 in Microsoft VBA
- #9 in Visual Basic Programming (Books)
- #116 in Spreadsheet Books

Customer Reviews:
272 ratings

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

5 star		69%
4 star		14%
3 star		9%
2 star		5%
1 star		2%

How are ratings calculated?

Top reviews from the United States

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

Errol C. Isenberg

Excellent professional-caliber book

Reviewed in the United States on August 17, 2018

Verified Purchase

With this book, someone who does not know Visual Basic for Applications (VBA) programming can learn to create Excel tools of the highest professional quality. I did not know VBA when I started using this book. Since starting to use this book a couple of years ago, I have developed and implemented in production for the state government agency where I work several Excel tools that are used by upper management on a daily basis. I would not have been able to develop those tools without the use of this book. The knowledge I gained from this book enabled me to get a promotion and increase my salary. I still use the book every week.

9 people found this helpful

Helpful

Nick Rinz

Great for VBA Newcomers

Reviewed in the United States on May 10, 2018

Verified 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

3 people found this helpful

Helpful

johncblacker

Not all it's hyped to be

Reviewed in the United States on May 3, 2019

Verified Purchase

I bought this based on it's rating but was somewhat disappointed. It's quite thorough, yet there are still questions that I had to look up online. With the size of this book, the author could have put in a basic VBA beginner chapter. Found the index to be lacking important subjects, and some subjects while mentioned didn't have examples - like how to open a workbook from within a VBA excel app.

3 people found this helpful

Helpful

P. H. Lasky

Contains too few basic code snippets and is just too voluminous for quick reference.

Reviewed in the United States on August 5, 2020

Verified Purchase

To refresh my knowledge of VBA which I use rarely. Also use it to obtain code snippets that perform standard tasks like counting the number of rows in a data base. The book contains an enormous number of topics 95% of which are superfluous that manipulate spread sheets. I only need explanations of code to process numbers, not whole spreadsheets. for my needs the book is just ok. It’s just too large and covers too few basic code snippets to be a valuable resource.

Helpful

GeoFam

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

Reviewed in the United States on November 30, 2015

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

7 people found this helpful

Helpful

Rip Van Winkle

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

Reviewed in the United States on August 22, 2015

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

10 people found this helpful

Helpful

Reefer

Excellent VBA reference

Reviewed in the United States on March 12, 2017

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

5 people found this helpful

Helpful

minnesota reader

This is the gold standard.

Reviewed in the United States on October 4, 2015

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

4 people found this helpful

Helpful

Top reviews from other countries

Chief Goober

More of the same, still excellent

Reviewed in the United Kingdom on July 22, 2014

Verified Purchase

It's a great book, perfect for users comfortable with Excel generally but wanting to learn VBA. It's always the book I recommend people to start with. There are a lot of nice examples and the majority of things you will encounter whilst doing VBA are covered in some respect - even if you might seek additional specific advice elsewhere on the net.
The 2013 vs. the 2010 version do not seem particularly different - as VBA hasn't really changed too much since 2007 I guess. Disappointing that the 2013 paper book does not come with the CD-ROM containing a .pdf version of the book (along with examples) that the 2010 paper book did.

12 people found this helpful

Shirley M

Another great John Walkenbach book

Reviewed in the United Kingdom on February 8, 2016

Verified Purchase

I love John's books! Easy to use, well organised, lots of examples, etc. I'm an experienced Excel/VBA developer, but always find new tips and tricks. But don't be put off if you're just starting out; assuming you have a basic understanding of Excel, this isn't too daunting for beginners. John also has a great writing style, and I love the little bon mots he includes to lighten the geekiness!

2 people found this helpful

Kevin Dearn

Excellent Resource for Excel 2013 VBA Programming

Reviewed in the United Kingdom on January 14, 2019

Verified Purchase

This book has proved invaluable to me over the years as I have created macros inn Excel 2013. I cannot recommend this book enough. Each topic is explained clearly and with examples , soft copies which are made available by the author.

Bob Patterson

Great book

Reviewed in the United Kingdom on February 24, 2015

Verified Purchase

As always with "Mr Excel" this is a terrific book, extremely well written and in language that makes the "other" side of Excel accessible. Book was well packaged and delivered quickly.

4 people found this helpful

Leshawk

Comprehensive Introduction

Reviewed in the United Kingdom on September 19, 2013

Verified Purchase

To be fair Im still working through this book. Nonetheless it is helping me to consolidate my VBA knowledge. IMHO suitable for beginners too.

8 people found this helpful

See all reviews

What other items do customers buy after viewing this item?

Page 1 of 1 Start overPage 1 of 1

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

Excel 2013 Power Programming with VBA 1st Edition

Frequently bought together

Customers who viewed this item also viewed

Customers who bought this item also bought

Special offers and product promotions