Visual Basic for Excel
State ID
G013P
Simple concept, massive efficiency.
Harness the power of one of Microsoft Excel's most useful functions, and improve your speed, efficiency and work output dramatically in this hands-on short course.
Image
CampusesKalgoorlie.
When Semester 2, 2024.
Study Mode On campus.
Learn to dramatically increase your efficiency using Visual Basic for Applications (VBA) in Excel.
You will learn to create command procedures, write simple code and use a range of common programming techniques to manipulate, analyze, and present data more easily and efficiently.
Topics covered include:
- 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 and to drive a user form
- use a range of common programming techniques
- create a custom form complete with controls and event procedures
- create procedures that start automatically
- write a variety of error handling routines
Select your preferred campus and apply
Semester 2, 2024
Details
Duration
2 Days
When
Semester 2, 2024
Where
Kalgoorlie
How
On Campus
Course fees
$600.00
Please note: Course information and fees are subject to change without notice.
- Fees may differ between campus locations due to the difference between elective units in the course study plan or a need to adapt courses to meet local industry needs.
- Fees may also differ for individuals depending on units of study selected, prior qualifications and recognition of prior learning (RPL).
- Fees are payable at the time of enrolment.
- Total fees quoted include tuition fees and resource fees. You may also be required to purchase text books, uniforms or other personal equipment that are not included in this fee estimate.
- For Lower Fees, Local Skills (half-price) courses please refer to additional eligibility information above.
- Concession rates: If eligible, proof of concession must be presented.
- Concessions and the secondary school age fee cap do not apply to commercial courses (short courses), or Foundation Programs (i.e ESL and General Education).
- Secondary school aged persons (in 2024, students born on or after 1 July 2006 who are at least 15 years old in 2024) undertaking training that is not part of a VET Delivered to Secondary Schools program, the maximum course (tuition) fee chargeable is $420. Additional resource fees and discretionary fees may apply.
- VET Student Loans for eligible courses and fee caps may be subject to changes implemented by the Australian Government.
More information: Visit our fees and payment options page or call us on 1800 672 700
Units
| National ID | Unit title |
|---|---|
| G0013 | Visual Basic for Excel |