The Microsoft Excel Macros & VBA Online Course builds on a basic knowledge of Excel macros learnt in Level 3 and introduces the power of the VBA language. Macros automate tasks to a point, but to fully automate manual processes in Excel the user must be able to edit the macro code and work directly and confidently with the VBA language. This course includes best practices and loads of shortcuts and tips to make using Excel actually enjoyable.
The online course includes videos that you can watch and rewind to learn techniques, step-by-step instructions to follow, and loads of exercises and quizzes to reinforce your learning. The course comes with a tutor who you can call, email or meet via MS Teams if you need that extra bit of support.
At the completion of the course, you will be issued with a Certificate of Completion.
Register and join us today!
Comprehensive coverage of:
- creating, running and manipulating macros
- editing and writing VBA code
- referencing the Excel object model
- Input Boxes, Message Boxes and Variables
- WEND, IF End IF, Do Loop, For Next statements
- Select Case
- referencing all Excel objects
- debugging and error handling
- and more
This Online Course is ideal, if you struggle to find time to attend a course, and you want to learn in the privacy of your own home, during the hours that you find the most convenient. Learn at your own speed and in your own time and don't deal with the pressure of trying to learn in a group classroom setting. Your online classroom does not expire, so you can take your time and you have access to your own personal tutor via phone, email or MS Teams.
Microsoft Excel - Macros and VBA Programming Online Course (Level 6)
A knowledge of how to create and run basic macros is required.