, ,
Home | Courses | Visual Basic for Excel

Visual Basic for Excel

State ID: G013P

A short course in Visual Basic for Applications (VBA) in Excel will equip you with the technical skills and required knowledge to create automated processes within Excel. You will learn to create command procedures, write simple code and use a range of common programming techniques to manipulate, analyse, and present data more easily and efficiently.

Course Content

•    create recorded macros in Excel
•    use the macro recorder to create a variety of macros
•    understand the Excel object model and VBA concepts
•    work with the three main components of the VBA Editor window
•    create command procedures
•    create and work with user defined functions
•    write code to manipulate Excel objects
•    use a range of common programming techniques
•    create a custom form complete with controls and event procedures
•    create code to drive a user form
•    create procedures that start automatically, and
•    write a variety of error handling routines.


Upon completion of this course you will receive a Certificate of Participation.


To find out more about studying with us please refer to our Course Guide and Student Information Pack.

Important information

How to apply

Important information


2 Days


Full:  $590.00

Other Information 

For additional information or to enrol contact our Commercial Training Coordinator - Tracy Hicks

(08) 9088 6830

How to apply
On Campus (Full-Time or Part-Time)
 Visit our Apply and Enrol page to find out how to apply for full-time, part-time or online courses.  
Flexible and Other Study Types 
We take applications for many of our flexible courses all year round.  Visit the Apply and Enrol page and use our Applicant Portal to lodge your application anytime. 
Apprenticeships and Traineeships 
For apprenticeships and traineeships, you must be employed in a training contract by an appropriate organisation to study. Find out more here.
International Students 
International students please visit www.tafeinternational.wa.edu.au Opens in a new window 
Short Courses and Skill Sets

Enrol in a short course or skill set by:

Calling your local campus on 1800 672 700 or completing the short course enquiry form at the bottom of your selected course page.


Delivery location, important dates and study options

Semester 2, 2019

Kalgoorlie Campus - Visual Basic for Excel - 12 to 13 September



Duration 2 day/s
When Semester 2, 2019
Where Kalgoorlie Campus
How Face to face (class room)
Apply now
Ready to apply for this course? Check out the apply and enrol page for more information.

Course enquiry

Please note: This form is only for course enquiries. If you would like to apply or require further application information, please visit our Apply and Enrol page.

Page last updated July 18, 2019