After the completion of this training, you will be able to:
- Create/update/robust macros using VBA coding to create custom solutions, automate repetitive tasks, and increase performance
- Handle/Create Spreadsheets, PowerPoint, Outlook Emails, File and database objects using VBA code
- Access VBA development environment and write generic, documented, easy-to-understand code
- Learn about the different data types in VBA and their specific uses
- Understand the concepts of conditional statements and loops and integrate them into your code
- Learn how to apply formatting via VBA
- Implement basic data handling and storage through the use of arrays, collections, and dictionaries
- Write reusable code for repetitive tasks and call them during normal coding usage
- Learn the various methods to access charts, shapes, form controls like dropdowns, list boxes, etc.
- Learn the basics of error handling in VBA
- Learn about user forms and their applications in VBA
- Implement classes and Object-oriented programming in VBA