Home | Short courses | VISUAL BASIC FOR EXCEL

VISUAL BASIC FOR EXCEL

State ID: G8922

 

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.

Specifically you will learn about:
•    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.

Please also refer to the Student Fact Pack for additional College and support information.

Pre-requisites

Study pathway

Job opportunities

Pre-requisites
Study pathway
Job opportunities

Delivery location, important dates and study options

Overview

Outline

Fees and charges

About the lecturer

Other requirements

Overview

Course Overview

Where Kalgoorlie
Duration 2 days
HowFace To Face (Class Room)
When

Next class: 9-10 November 2017

2018 course dates will be published as soon as they are available.

Outline
Fees and charges

This course costs $590.00

About the lecturer
Other requirements

It's easy! Apply now by calling the Campus that the course is offered at OR email us at info@crtafe.wa.edu.au and we will get back to you!

 

Enquire now
Call us
Email us

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.

For help enrolling or for more information contact Commercial Business Coordinator: Tracy Hicks on 9088 6830 or tracy.hicks@crtafe.wa.edu.au.

O alternatively Client Services on 1800 672 700 or email info@crtafe.wa.edu.au

Please note: All enrolling students will require a Unique Student Identifier number 

Entrance Requirements

School Leaver Non-School Leaver AQF

For help enrolling or for more information contact Commercial Business Coordinator: Tracy Hicks on 9088 6830 or tracy.hicks@crtafe.wa.edu.au.

O alternatively Client Services on 1800 672 700 or email info@crtafe.wa.edu.au

Please note: All enrolling students will require a Unique Student Identifier number 

Entrance Requirements

School Leaver Non-School Leaver AQF

Qualification level

Links

Page last updated November 17, 2017