Course Topics
- What is Macro
- Recording and running macro
- Security Levels in Macro
- Editing macros using VBA Editor
- Understanding the project explorer
- Exploring properties window
- Modifying code in code window
- Variables, data types and constants
- Arrays
- Object variables
- Conditional Structures (If…Then, Select Case)
- Logical Operators
- Looping Constructs
- Built in functions
- Designing Forms
- Creating Subroutines
- Advanced Programming Techniques
- Introduction to UDF’s
- Creating and Working with UDF’s
- Developing Excel Utilities with VBA
- Working with Pivot Tables & Charts
- Understanding Excel Events
- Interacting with other Applications
- Creating and Using Addins
