Excel 2016 power programming with VBA

Introduction to Excel VBA. Essentials of spreadsheet application development ; Introducing Visual Basic for Applications ; VBA programming fundamentals ; Working with VBA sub procedures ; Creating function procedures ; Understanding Excel's events ; VBA programming examples and techniques

Advanced VBA techniques. Working with pivot tables ; Working with charts ; Interacting with other applications ; Working with external data and files

Working with UserForms. Leveraging custom dialog boxes ; Introducing UserForms ; UserForm examples ; Advanced UserForm techniques

Developing Excel applications. Creating and using add-ins ; Working with the ribbon ; Working with shortcut menus ; Providing help for your applications ; Leveraging class modules ; Understanding compatibility issues

Appendix. VBA statements and function reference.