VBA Basic for Excel

Commencement Dates

Please contact us for schedules.


Course Duration

15 Hours

Target Audience

If you are non-programmer, who likes to understand the basic of Excel VBA programming. 


Proficient with relevant working experience in Microsoft Excel.


Successful trainees will receive Certificate of Attainment from Genetic Computer School

Course Pathway

VBA Advanced for Excel.


Introduction to Excel VBA 2010easily witrh our step by step, practical, hand on workshop in Singapore. After attending the Basic Excel VBA training, you will be able to:

  • Understand what is VBA or Macro
  • Record and Run Macro easily
  • Understand what is VBE and tools

Course Details




Section 1 : Introducing Excel with VBA Programming

What is VBA
A brief history of VBA
What can VBA do for you?
Advantages and Disadvantages of VBA
Different versions of Excels
Know how to run a Excel Macro in 2007/2010
How to migrate Excel Macro 2007 to 2010

Section 2 : Getting Started with Macros

Accessing the VBA Environment
Recording the Macro
Testing the Macro
Examining the Macro
Modifying the Macro
Understanding Macro Security
Saving Workbooks that contain Macros

Section 3 : Introducing the Visual Basic Editor                                 

What is the Visual Basic Editor
How to get into VBE
Understanding the VBE components 
Understanding Modules
Using the Object Browser
Exiting the VBE

Section 4 : Working in the VBE

Toolbars in the VBE
Locating Your Macros
Understanding the Code
Editing a Macro with Comments
Deleting a Macro
What is a VBA Module 
Inserting a VBA Module 
Renaming a VBA Module 
Deleting a VBA Module
Locking and Protecting the VBE


Fees Structure

Promotion Course Fee : $380/-

Thank you for your enquiry. One of our course consultants will keep in touch with you shortly.

Request more information

What would you like to request?


Adobe authorized training center
WSQ work skills qualification training center
ICDL test center
EduTrust CPE Singapore
Registration No: 198902296M
24 June 2015 to 23 June 2019
Main Office
Block 118 Aljunied Avenue 2
#02-100 Singapore 380118
Tel: +65 6339 7588
Bedok Branch
Blk 209 New Upper Changi Road
#04-643 Singapore 460209
Tel: +65 6913 4572
Jurong Branch
CPF Jurong Building 21
#03-09/10 Jurong Gateway Road
Singapore 150167
Tel: +65 6912 4316
Bukit Merah Branch
Blk 167 Jln Bt Merah Tower 4, Connection One
#06-11A Singapore 150167
Tel: +65 6928 0735