This training contains the essential of VBA knowledge. It prepares the user to explore more advanced techniques in VBA. There will be several exercises to apply the new skills learned every chapter.
Participants will be able to automate reports to improve efficiency, lessen errors, and lessen the impact to productivity when a skilled person resigns.
Part 1. Macro Recording
Part 2. Introduction to VBA
Part 3. Programming Basics
Part 4. Control Structures
Part 5. Creating Your Own Functions
Part 6. Creating Userforms and Userform Events
Part 7. Error Handling
Part 8. Creative Automation Exercises in VBA