Tel: 1300 TO TRAIN

Email: info@advancedtraining.com.au

IT Training with Advanced Training



VBA for Excel (Intelligent Programming with VBA Excel)


Course Description

This course aims to increase your productivity by providing the skills and knowledge to use programming VBA code in Excel 2003 effectively.

Pre-Requisites

This course is designed for participants who have a sound working knowledge of Excel 2003. Participants should have extensive experience in formulas, ranges, functions and multiple workbooks.

Outcome

At the completion of this course, participants will be able to:

  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros
  • create and work with user-defined functions
  • work with the main components of the VBA Editor window
  • create command procedures
  • create and use variables
  • write code to manipulate Excel objects
  • use a range of common programming techniques
  • create a custom form complete with controls and event procedures.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.




User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info


Next Step

Enquire Now
Tell a Friend
Email Course Outline

Course files