Excel 2016 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)
Excel 2016 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) book cover

Excel 2016 Power Programming with VBA (Mr. Spreadsheet's Bookshelf)

1st Edition

by
Price
$17.48
Format
Paperback
Pages
768
Publisher
John Wiley & Sons
Publication Date
ISBN-13
978-1119067726
Dimensions
7.3 x 1.8 x 9.2 inches
Weight
2.25 pounds

Description

From the Inside Flap Become a power user with VBA Take your Excel skills to the next level by harnessing the power of the VBA language. This comprehensive resource will help you automate data processes and develop full featured Excel programs. Fully updated for the newest release of Excel, this one-of-a-kind resource presents everything you need to develop both large and small Excel applications. This book was designed with you in mind, giving you straight facts without hype or unnecessary explanations. This book offers tips, tricks and practical examples complete with all the code and sample templates you need to start your journey from humble data analyst to Excel programming pro. Let Mr. Spreadsheet show you how to: Go beyond recording simple macros Go beyond recording simple macros Dynamically manipulate workbooks and worksheets Dynamically manipulate workbooks and worksheets Automate pivot table and chart features Automate pivot table and chart features Manage external data and wrangle external files Manage external data and wrangle external files Send emails directly from Excel Send emails directly from Excel Create your own Excel Ribbon interface Create your own Excel Ribbon interface Develop and distribute your own Excel Add-ins Develop and distribute your own Excel Add-ins COMPANION WEBSITE Visit the companion website at www.wiley.com/go/excel2016powerprogramming to find files used as examples in the book From the Back Cover Become a power user with VBA Take your Excel skills to the next level by harnessing the power of the VBA language. This comprehensive resource will help you automate data processes and develop full featured Excel programs. Fully updated for the newest release of Excel, this one-of-a-kind resource presents everything you need to develop both large and small Excel applications. This book was designed with you in mind, giving you straight facts without hype or unnecessary explanations. This book offers tips, tricks and practical examples complete with all the code and sample templates you need to start your journey from humble data analyst to Excel programming pro. Let Mr. Spreadsheet show you how to: Go beyond recording simple macros Go beyond recording simple macros Dynamically manipulate workbooks and worksheets Dynamically manipulate workbooks and worksheets Automate pivot table and chart features Automate pivot table and chart features Manage external data and wrangle external files Manage external data and wrangle external files Send emails directly from Excel Send emails directly from Excel Create your own Excel Ribbon interface Create your own Excel Ribbon interface Develop and distribute your own Excel Add-ins Develop and distribute your own Excel Add-ins COMPANION WEBSITE Visit the companion website at www.wiley.com/go/excel2016powerprogramming to find files used as examples in the book About the Author Michael Alexander is a Microsoft Certified Application Developer and author of several books on Microsoft Access and Excel. He runs a free tutorial site at datapigtechnologies.com. Dick Kusleika has been helping users get the most out of Microsoft Office products for more than fifteen years through online forums, blogging, books, and conferences. John Walkenbach is arguably the foremost authority on Excel. He has written more than 30 books and maintains the popular Spreadsheet Page at http://spreadsheetpage.com Read more

Features & Highlights

  • Maximize your Excel experience with VBA
  • Excel 2016 Power Programming with VBA
  • is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved collaboration features. In addition to the procedures, tips, and ideas that will expand your capabilities, this resource provides you with access to over 100 online example Excel workbooks and the Power Utility Pak, found on the Mr. Spreadsheet website.
  • Understanding how to leverage VBA to improve your Excel programming skills can enhance the quality of deliverables that you produce―and can help you take your career to the next level.
  • Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques
  • Explore fully updated content that offers comprehensive coverage through over 900 pages of tips, tricks, and techniques
  • Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text
  • Leverage templates and worksheets that put your new knowledge in action, and reinforce the skills introduced in the text
  • Access online resources, including the Power Utility Pak, that supplement the content
  • Access online resources, including the Power Utility Pak, that supplement the content
  • Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office
  • Improve your capabilities regarding Excel programming with VBA, unlocking more of your potential in the office
  • Excel 2016 Power Programming with VBA
  • is a fundamental resource for intermediate to advanced users who want to polish their skills regarding spreadsheet applications using VBA.

Customer Reviews

Rating Breakdown

★★★★★
60%
(140)
★★★★
25%
(59)
★★★
15%
(35)
★★
7%
(16)
★
-7%
(-16)

Most Helpful Reviews

✓ Verified Purchase

Good read. Strong on examples. Understandable. Digestable. No real soup to nuts projects inside is it's weak point.

The author's put out a lot of these books. He's a good read and offers a ton of helpful advice. My issue is that the book (like all VBA books it seems) is for beginners in VBA. If you have never programmed in your life or have very little experience at all, this is an excellent primer. If, on the other hand, you've been using Excel for a decade or more as I have and are looking to "deepen" your knowledge, this book is a hunt and peck affair. But again, the downloads help a lot to resolve this. Page 303 on pivot tables has an error in the code (i should be 2 to 14 and not 1 to 14 in the loop), but otherwise the examples and the downloads seem to match up just fine. One issue I have with all "not Sybex" and "not Murach" publishers is that the books give a ton of disconnected examples where as those two publishers run the reader through several projects from start to finish so the reader receives a keyboarding experience that is connected and is a better learning tool. This is a publisher issue more than an author issue, and it depends on what the reader expects too I suppose. The book is well worth the price for the beginner to intermediate, and as an intermediate/advanced reader re-learning a language I abandoned a decade ago, it's a good refresher. However again, the index isn't that useful, so I find Mr. Google doing most of the lookups. (I know what I want to do, I just don't remember the exact syntax) Lastly, if you don't understand OOP principles, I would suggest another book focusing on programming structure to help you with OOP in addition to this one. The examples are filled with OOP framework, but since no project is there per se, the reader might not realize this if they don't already have that knowledge—and OOP is a powerful structure to work from. BASIC didn't start out with OOP when I first learned it. And OOP is key to code efficiency and speed. Best of luck to all and my thanks to the authors.
74 people found this helpful
✓ Verified Purchase

The link to download the files doesn't work

The link published in the book to download the example files is not working. When I searched the web to find the files, they were downloadable by chapter, which is very time consuming. There should be one zip file to download and get all of them.
11 people found this helpful
✓ Verified Purchase

This has definitely been worth my $$$.

I knew nothing of VBA before using this book. After reading the first 2 chapters, I've practiced on a variety of my personal and professional spreadsheets and I've been impressed with what I can do now. I don't know how I lived without VBA in the past. I'm still by no means skilled, but I've learned enough to have fun and be very productive with it. I'm looking forward to learning more and putting these new skills into practice at work. This has definitely been worth my $$$.
7 people found this helpful
✓ Verified Purchase

Not very useful..

Lots of key material missing. Not very useful . . . I end up looking up info on the web.
5 people found this helpful
✓ Verified Purchase

Disappointing

I am very disappointed in this book. I expected more from Walkenbach as I have this series from Excel 2000 forward. In fact, my 2000 copy is falling apart from use as a reference manual.
It appears that the covers were just replaced from 2010 to this.
There is no mention of Microsoft moving from multiple document interface to single document interface (making it a challenge for macros to work across workbooks without the use of an add-in (the book did mention add-ins - albeit briefly).
Also, there is no mention of power query, power pivot, power BI, or data models.
I expected more for John.
4 people found this helpful
✓ Verified Purchase

Four Stars

Great reference book. Greatly strengthens my ability.
4 people found this helpful
✓ Verified Purchase

Nothing new or impressive here unless you are new to VBA

The worst thing about this book is that it is the SAME as my copy of Excel 2013 Power Programming with VBA that I did not see on my shelf until after I got this.

Power programming is an overstatement. I have seen much more useful and sophisticated code FOR FREE on the internet.

Big mistake .. but I had a B&N gift card
2 people found this helpful
✓ Verified Purchase

Microsoft announced only one office platform the same Mac and ...

Microsoft announced only one office platform the same Mac and Windows the first pages of the book says only for Windows, and there is big gap between VBA for Windows and Mac.
I believe Mac users have been abused by Microsoft highly descriminated.
2 people found this helpful
✓ Verified Purchase

Excel Reference Book

An excellent reference book even for experienced Excel users.
2 people found this helpful
✓ Verified Purchase

Five Stars

Everything I expected it to be. Now just need to find more time to learn it well.
1 people found this helpful

Related Books