Description
This two-day advanced Excel training class teaches the foundational skills in Microsoft’s programming language for Excel. You will learn how to take complex and time-consuming tasks and automate them with code. As far as coding languages go, VBA is one of the easier languages to learn and should be known by those in or seeking a role in data science.
– Previewing Complete Course Projects and their Code
– Introduction to Visual Basic for Applications
- • VBA vs. Macros
- • Recording a macro in Excel
- • Explore VBE Settings
– Understanding the Excel Object Model
- • Understanding Collections
- • Referencing Objects
- • Simplifying Object References
– Procedures, Method and Scope
- • Working with Methods
- • Executing Sub-Procedures
- • Scope of Procedures
- • Event Procedures
- • Function Procedures
– Foundational VBA Language Elements
- • Variables, VBA Data Types, Variable Scope and Declaring Variables
- • Intrinsic Functions
- • With-End Structure
- • Message and Input Boxes
- • Object Variables
– Controlling Program Flow
- • Control-of-Flow Structures
- • Boolean Expressions
- • Conditional Branching
- • Looping Constructs
– Forms and Controls
- • Forms and Controls
- • Formatting Form Controls
- • Coding Form Controls
- • Launching a Form with Code
– The PivotTable Object
- • Creating a PivotTable in Excel
- • Creating a PivotTable Programmatically
- • Finalizing the Form
- • Adding Code to a Button in Excel
– Dealing with Code Errors
- • Types of Coding Errors and their Causes
- • Using the Debug Toolbar to Investigate Errors
- • Tips for Minimizing Errors
- • Error-Handling
– Error-Handling
- • Error-Trapping Options
- • On Error Statements
- • Protecting your Code