support@vit.edu.au    1300 171 755       

MS Excel 2013 – VBA

Course Name MS Excel 2013 – VBA
Course Code VIT/05/5013
Course Type Desktop Application
Cost $399.00 Enrolment Form
Duration One day
Times Part-time / Full Time:
Weekends, Week Days, Evenings
Outline This instructor lead course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel 2013 VBA (Visual Basic for Applications programming) effectively.
Objectives
  • Understand the Excel object model and VBA concepts
  • Work effectively with the main features of the VBA Editor window
  • Create procedures in VBA
  • Create and use variables
  • Create and work with user-defined functions in VBA
  • Write code to manipulate Excel objects
  • Use a range of common programming techniques
  • Create a custom form complete with an assortment of controls
  • Create code to drive a user form
  • Create procedures that start automatically
  • Write a variety of error handling routines.
Modules
Other
Material The course material will be provided.

Testimonials

  • “I benefitted greatly from this course while still working in the workplace (restaurant).”


    - Kishan S

  • I was very happy with my time at VIT studying hospitality. I don’t think there is anything I would change, everything was good”


    - Vijay S

  • Excellent trainer, thoroughly enjoyed the course. Was well paced and time went quickly. Appreciated being able to complete some projects as a group in class, venue convenient and all facilities required were available


    - Ms. Christine G

  • Very good relationships developed from the beginning. Staff members have been fantastic even before commencement of the course. They made my time in class informative and pleasurable


    - Mr. Michael G

  • Very well structured course. I have got a lot out of this course and looking forward to putting my new skills and knowledge to work –


    - Ms. Melissa C

  • First time I have had such a positive, intelligent and charismatic trainer. He has a talent for training and made a challenging course achievable with his attitude and advice. I would definitely like to study with him in future on another course and have enjoyed the time


    - Mr. Jason P

  • Fantastic opportunity to be a student of VIT. Excellent trainer and best Administrator, thanks for their help and support


    - Ms. Ramanpreet P

  • The course was very good. Trainer was fantastic and was flexible and informative


    - Ms. Rebecca B

  • So far the course has been fantastic with a patient and understanding teacher.  The course is very informative and helpful with my current job.


    - Mr. Chris C

  • The written information I found to be useful, well written, concise. The instructor was very helpful in any difficulties that I experienced. Also very knowledgeable and very communicative. I would recommend this course.


    Web theme by Online Pokies website where you can play pokies online for free via this online pokies websites


    - Mr. Effie S

  • It is a very enjoyable and informative class.


    - Mr. Sylvie T

  • The course gave me confidence though it was a little challenging. My teacher was friendly and very helpful.


    - Mr. Vincen R

  • My English teacher is responsible and patient who uses simple ways to help us understand English words.


    - Mr. Yuwen Z

  • Our English teacher is a nice person who is patient, responsible and kind.


    - Mr. Li Y

Watch VIT Video

International Overview

ABOUT US

VIT aims to provide you with a smart start to your education, giving you a better and brighter future.
Read More

GET IN TOUCH

Contact us via phone, email or social media, we look forward to hearing from you.

Email us
support@vit.edu.au

1300 171 755

Follow us on:

About VIT|Contact Us| Disclaimer & Copyright|Privacy Policy
© Copyright VIT(Victorian Institute of Technology Pty Ltd) 2017
Melbourne Campus Address: Level 14, 123 Queen Street, Melbourne, Victoria 3000 Australia Fax: (613) 9670 7849
Sydney Campus Address: Level 5, 333 Kent Street, Sydney, New South Wales 2000 Australia
Email:info@vit.edu.au RTO No: 20829, TEQSA Provider No: PRV 14007, CRICOS Provider Code: 02044E, ABN: 41 085 128 525