VBA Basic for Excel

Commencement Dates

Please contact us for the schedule.

Overview

Course Duration

15 Hours

Target Audience

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

Pre-requisites

Proficient with relevant working experience in Microsoft Excel.

Certification

Successful trainees will receive Certificate of Attainment from Genetic Computer School

Course Pathway

VBA Advanced for Excel.

Objectives

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

DESCRIPTION

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?



+



WE ARE...
Adobe authorized training center
WSQ work skills qualification training center
ICDL test center
EduTrust CPE Singapore
GENETIC COMPUTER SCHOOL
Registration No: 198902296M
24 June 2015 to 23 June 2019
OUR LOCATION
Block 118 Aljunied Avenue 2
#02-100 Singapore 380118
Tel: +65 6339 7588