Our Clients
Large MNCs, Local Companies & SMEs have selected Intellisoft Systems as their Training Provider.
Some of our clients are M1, Bayer, 3M, DSO National Labs, OLAM International, National Healthcare Group, HP, NUS, ITE, LTA, MOH and many more.
Advanced Excel VBA (Macro)
Advanced Excel 2007 VBA Course Objectives:
After attending the VBA Macro Training 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
Detailed Outline for 3 Day VBA Macro Training
Lesson 1:
- Make a Macro do Simple Tasks
- Difference between VBA & Macro
- Creating a Simple Macro
- Changing Multiple Properties at Once
- Manipulating Recorded Properties
- Recording Methods in a Macro
Lesson2:
- Make a Macro Do Complex Task
- Opening the Report File
- Filling in Missing Labels
- Adding a Column of Dates
- Appending to the Database
- Deleting the Worksheet
- Explore Workbooks and Worksheets
- Understanding Workbooks
- Understanding Worksheets
- Explore Range Objects
Lesson 5:
- Explore Data Objects
- Working with Excel Table
- Working with Pivot Table Reports
Lesson6:
- Explore Graphical Objects
- Explore Chart Objects
Lesson 7:
- Control Visual Basic
- Creating Loops
- Managing Large Loops
Lesson 8:
- Extend Excel and Visual Basic
- Creating Custom Functions
- Handling Errors
Lesson 9:
- Launch Macros with Events
- Creating Custom Command buttons
- Handling Worksheet and Workbook Events
Lesson 10:
- Use Dialog Box Controls on a Worksheet
- Using a loan Payment Calculator
- Retrieving a Value from a list
- Protecting the Worksheet
Lesson 11:
- Create a Custom Form
- Preparing a form’s functionality
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 3 full day Excel 2007 VBA Course. Course starts at 09:00 and runs until 17:00, with a one hour break for lunch, and two short snack breaks.
Miminum Requirements: You must have good Excel skills and understand key concepts of spreadsheets, or equivalent. It is not necessary to have programming knowledge.
Excel VBA Course Location / Schedule
This course is scheduled to run at our Microsoft 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.



