PMP Exam Prep Tips

Receive PMP Exam Preparation Tips & Project Management Articles

Master Trainer Vinai's
articles are published in books,
magazines & newspapers

Our article in The Straits Times

Learning For Life

Subscribe to our Learning for Life Newsletter & Get Interesting Articles & Training Updates!

 Email:
Name:

Enquiry / Registration

Status
Enquiry Registration
Course Title*
Course Date*
Self / Company Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*
Number of Participants*

 

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.