Key Features "John Walkenbachs name is synonymous with excellence in computer books that explain the complexities of the worlds leading digital business tool. John Walkenbach, known as ""Mr. Spreadsheet,"" is author of more than 30 books. His website on Excel is the most frequently visited Excel site after Microsoft. The Mr. Spreadsheets Bookshelf series maximizes Johns selling potential by capitalizing on his franchise status. The series is designed to leverage our success with John Walkenbachs popular Excel power user titles. This edition of Excel Power Programming covers all the methods and tools you need to program with Excel. The book includes an analysis of Excel application development and a complete introduction to VBA." About the Book: Microsoft Excel 2013 Power Programming With VBA "Microsoft Office Excel is the leading spreadsheet application. It is a key module in Microsoft Office, the number-one productivity suite." "This book is indispensable for Excel intermediate users, power users, and would-be power users. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers wont find anywhere else. Thoroughly updated to cover the Excel interface, file formats, enhanced interactivity with other Office applications, and upgraded collaboration features. " Content Some Essential Background Understanding Visual Basic for Applications Working with User Forms Advanced Programming Techniques Developing Applications Other Topics" About the Author: John Walkenbach "John Walkenbach, principal of J-Walk and Associates, Inc. is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books and 300 articles and reviews for publications including PC World, InfoWorld and Windows. He also maintains the popular Spreadsheet Page at spreadsheetpage.com and promotes all his books at that site."
This book is for intermediate excel users and it is better to use it as guidance for dealing with VBA programming. The author is so right when he suggests readers to skip around, picking up useful tidbits here and there. Indices of the book offer easy-to-find solutions for VBA programming problems. https://vebimo.wordpress.com/2017/09/...
This amazing book helped me to shift my career and work for two years as an Excel-VBA developer online. The book starts with basics in VBA and Excel. Then illustrates advanced techniques and methods to enhance the VBA code. Unlike other books and tutorials, the book do not invent the wheel and will use Excel tools and formulas when ever it is possible.
In my opinion, it is a "must read" for any one wants to work as a VBA developer.
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.