VBA (Visual Basic for Applications) is the programming language built into Microsoft Excel. With VBA, you can take repetitive tasks in Excel and put them on autopilot.
In this hands-on class, you'll learn the fundamentals of VBA programming by working through real-world applications of macros and Excel automation. You'll learn how to automate repetitive operations, create custom commands, develop new worksheet functions, and more.
What You Will Learn
- Security
- Recording macros
- Reading and analyzing code
- Programming basic macros
- Building complex macros
- Variables
- Looping statements
- Logic statements
- User forms
- Error trapping
- Troubleshooting
This program is available for 60 days. You can choose when to start your access period. Once you activate, you will have 60 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.