itEnabler
+CISCO
+Android Programming Course
+SQL Scripting
+MS SQL Server 2012
- MS SQL Server 2012 Database Administration
- MS SQL Server 2012 Database Querying

+Oracle Database SQL
- Oracle Certified SQL Expert

+ITIL
+VBA Excel / Access / Word
+Web Design & Ecommerce
+Web Development &
  Programming

- SQL Scripting
- Adv SQL Scripting
- Javascript
- HTML5 with JavaScript and CSS3
+Microsoft Infrastructure Certification

CompTIA Courses


+

Basic Networking & IC3 Courses



Register Courses at IT Enabler
Home > Course List > VBA for Excel 2010/2013
VBA Excel Course Singapore - VBA Excel 2010/2013

Course Objective:

The 3-day VBA Excel course in Singapore guides participants in using some of Excel's commonly used formulas. Participant also learns how to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of database development.

In this course, participant will apply the Visual Basic for Applications (VBA Excel ) programming language to simplify many of the tasks in Excel 2007/2010/2013 environment.

Participants will be proficient in using VBA to create macros for automating repetitive tasks in Excel 2007/2010/2013


Prerequisites:
Prior knowledge for Excel 2007/2010/2013 and especially suitable for students who had attended Excel 2007/2010/2013 Intermediate and Advance course.

Certificate Of Attendance:
Certificate Of Attendance will be awarded to trainees completing the course achieving minimum 75% attendance.

Training Duration:

Full-time: 3 Weekday / 3 Sats                Time : 9.30am - 5.30pm
Part-time: 6 Sessions                            Time : 7.00pm - 10.00pm (twice a week)

Course Outline:

1. Introduction to VBA in Microsoft Excel 2010/2013

  • Introduction to Visual Basic for Application (VBA)
  • Installing Visual Basic Editor for Excel 20010/2013
  • Setting up the Visual Basic Editor in Excel (VBE)
  • The VBE Menu and ToolBar
  • The VBE Object Browser
  • VBE Options
  • The Three Windows in the Visual Basic Editor
  • The Project Window
  • The Properties Window

2. The Macro Recorder in Excel 2010/2013

  • Recording Your First New Macro
  • Running your first recorded macro
  • Looking at your first recorded macro
  • Modifying a Macro in Excel

3. Starting, Triggering a Macro in Excel 2010/2013

  • Preparing the Exercise on Events
  • Macros Triggered from the Developer Ribbon
  • Macros Triggered by a Keystroke
  • Macros Triggered by Clicking on a Text Box on the Worksheet

4. :VBA Variables

  • Datatypes & VBA Variables
  • Static, Constants & Arrays
  • Enumeration Datatype
  • Scope of VBA Variables
  • Strings and String Manipulations

5. Working with Procedures and Functions

  • Understanding Proceures and Modules
  • Creating a Standard Module
  • Creating Procedures and Functions
  • Understanding the Local and Global Scope
  • Passing Arguments to Procedures and Functions
  • Using Instrinsic Functions.

6. Conditions, Branches and Looping Control

  • Using the If..Then..Else Statement
  • Nested If Statements
  • Case Statement and Choose Statement.
  • For Loop and For Each Loop
  • The Do While, Do Until, Do…While & Do… Until Loops

7. Debugging in VBA Excel

  • Testing & Debugging Step-by-Step
  • Break Points
  • Immediate Window
  • Watch Window and Add Watch
  • Local Windows

8. Error Handling

  • Introduction to Error types
  • Handling Errors
  • The Error Object
  • Debugging and Debug Print

9. Excel Object Model

  • VBA for Excel for Workbooks
  • VBA for Excel for Worksheets
  • Cells, Ranges, Columns and Rows in VBA for Excel
  • Message and Input Boxes (MsgBox, InputBox) in Excel

10. Userforms and Controls

  • Creating a Userform in Excel
  • Text Boxes in VBA for Excel
  • Command Buttons in VBA for Excel
  • Combo Boxes in VBA for Excel
  • List Boxes in VBA for Excel
  • Option Buttons, Check Boxes and Frames
  • Excel Spin Buttons
  • Excel Image Controls

11. VBA Macros Security and Protection in Excel

  • Password Protecting the code
  • Hiding and very hiding Worksheets
  • Protecting the Sheet
  • Protecting the Workbook
  • Password Protecting a single VBA Procedure

Download Course Brochure

Promotion Bundle:VBA Excel 2010/2013+Advanced VBA Excel 2010/2013=NICF-VBA Excel 2010/2013
Course Fees (Applicable to Non-NICF/Foreigner)
Course Title Normal Course Fees Promotional Course
Fees valid till
30-Jun-2016
Promo Course Fees w GST
NICF - VBA ExcelS$999.00S$899.00S$961.93
Registration FeeS$30.00S$30.00S$32.10
Total FeeS$1,029.00S$929.00S$994.03

Government Funding
Course is eligble for SDF Training Grant & Absentee Payroll from WDA. 
Course is eligible for PIC Grant from IRAS. 
Self-Sponsored trainee may use their SkillsFuture Credit Claim to offset the course fee payable. 
Terms and conditions apply. 

NICF Course Title : NICF - VBA Excel
Course Ref No. : CRS-Q-0028141-IT

NICF Funding Course Fees
NICF Funding
Singapore Citizens & Singapore PRs
Total Fee
Incl Regn Fee
Less
SDF Training
Grant
NETT
Fee
Excl GST 7%
NETT
Fee
Incl GST 7%
SME Company S$770.00S$666.00S$104.00S$157.90
Non-SME CompanyS$770.00S$370.00S$400.00S$453.90
Self-SponsoredS$770.00S$370.00S$400.00S$453.90*
 
Mid-Career Enhanced Scheme (MCES)
- Singaporean, 40 yrs & above
S$770.00S$666.00S$104.00S$157.90*
 
Workfare Trainig Support(WTS)S$770.00S$703.00S$67.00S$120.90*
 
Note: * - SkillsFuture Credit may be used to offset the course fees.


Course Title   Venue Register Online
Course Mode
Start Date
End Date
Time

All fees subject to prevailing GST.

Download VBA Excel Course Brochure

Download Advanced VBA Excel Course Brochure (Contact Customer Service @ 6333 4843)