This advanced two day Excel Macros Training Course is designed to teach attendees to discover (or enhance their existing) Excel VBA Macro skills in order to help automate and improve their Excel spreadsheets.
Furthermore, knowledge gained includes writing Excel VBA code, as well as building UserForms. Finally, Error trapping and custom User Defined Functions (UDFs) are covered in detail.
Audience & Duration
This two day Excel VBA Course (9am to 4pm WST) is an Advanced Course, which means that it is suitable for users who have solid, advanced skills in Microsoft Excel. Therefore, it will not suit anyone with limited Excel skills.
Students will learn how to record and edit Excel Macros and write Excel VBA code from scratch. At the same time, guidance is given about best practices for writing VBA code in Microsoft Excel. Consequently, attendees should be confident to create procedures and controls that control the behaviour and appearance of an Excel spreadsheet. Additionally, students should be able to create procedures that run in response to specific events, as well as create user forms to accept or display data.
Furthermore, course attendees should also be validate data entry user forms, and equally important, students should be able to debug and handle errors in code.
Last but not least, our Excel Macro Training Course attendees will learn how to create and deploy custom UDF (User Defined Functions).
Excel VBA Course Attendance
We offer a number of different ways to attend our Perth based Training, such as Public or Virtual Courses, as well as Workplace Training options. This is all in addition to the fact that you can also attend our courses online.
Public and Virtual Excel VBA Courses
We often run Excel Macro Training Courses at our venue in Perth, which can also be attended virtually (via ZOOM or Teams), from anywhere in Australia.
Workplace Excel VBA Courses
We also offer Workplace Training for companies. This means that we can run the course at your venue, or you can come to ours. With workplace courses, we supply laptops (with no rental fees), and can also cater for virtual students at the same time.
Custom Excel VBA Macros Training
In addition to this course, we also offer many other Training Courses for Excel, as well as custom Excel Training.
Online Excel VBA Courses
In addition to our standard delivery, we also offer the option to sit your course via our online training portal.