Advanced Excel VBA (Macro)

Advanced Excel 2007 VBA Course Objectives: After the course, you will be able to:

• Record and Run Macros
• Write VBA Code Manually
• Perform Loops, Controls and Error Handling
• Create User forms and Sheet Controls in Excel
• Use Events to trigger speciic VBA code

Intended Audience: This course is aimed at experienced Excel users who wish to automate repetitive tasks or simplify more complex tasks using Excel macros and Visual Basic for Applications (VBA) programming language.

Excel VBA Course Duration: This is a 2 full day Excel 2007 VBA Course. Course starts at 09:00 and runs until 17:00, with a one hour break for lunch.

What You Learn at a Glance:

• Lesson1:
  Introduction to Macros
   
• Lesson2:
  Introduction to Visual Basic For Applicaions
  Modules
  Procedures
  Objects, Methods & Properties
   
• Lesson3:
  Variables
  Data Types
  Functions
  Passing Arguments
   
• Lesson 4:
  Operators & Decision Making
  Relation & Logical Operators
  If…Then statement
  Select Case Statement
   
• Lesson 5:
  Do Loops
  While … Wend Loop
  For….Next Loop
   
• Lesson6:
  Introduction to Array
  declaring Array
  Array Function
   
• Lesson 7:
  Msgbox
  Dialog Boxes
  Creating Forms

Miminum Requirements: You must have good Excel skills and understand key concepts of spreadsheets, or equivalent to our Advanced Excel course level. It is not necessary to have programming knowledge.

Excel VBA Course Location / Schedule

This course is scheduled to run at our Excel 2007 training center at Beach Road in Singapore. View our Training Calendar for available dates. Enquire or Register by filling the form at the top right of this page.

Custom In-House / Corporate Training
The course can also be run on specific dates that suits you. Call our Corporate Training Hotline at (65) 6296-2995 if you have a group of 5 or more participants.  You can email to training@intellisoft.com.sg for Corporate Training Rates.