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/2016
VBA Excel Course Singapore - VBA Excel 2013/2016 (NICF - VBA Excel)

Course Objective:

This 4-day course 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) programming language to simplify many of the tasks in Excel 2010/2013/2016 environment.

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

Participants looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, participants who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.


Prerequisites:
Prior knowledge in Excel 2003/2007/2010/2013 and especially suitable for participants 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: 4 Weekday / 4 Sats              
Time : 9.30am - 5.30pm

Course is eligible for SDF Training Grant and Absentee Payroll.
Company may also claim PIC.
Self-sponsored trainees may apply for SkillsFuture Credit Claim.
Terms and conditions apply

Course Outline:

1. Getting Started with VBA Excel
• Introducing Visual Basic for Applications
• Displaying the Developer Tab on the Ribbon
• Recording a Macro
• Saving a Macro Enabled Workbook
• Running a Macro
• Editing a Macro in the Visual Basic Editor
• Understanding the Development Environment
• Using Visual Basic Help
• Closing Visual Basic Editor
• Understanding Macro Security

2. Working with Procedures and Functions
• Understanding Modules
• Creating a Standard Module
• Understanding Procedures
• Creating a Sub Procedure
• Calling Procedures
• Using the immediate Window to call Procedures
• Creating a Function Procedures
• Naming Procedures
• Working with the Code Editor

3. Understanding Objects
• Understanding Objects
• Navigating the Excel Object Hierarchy
• Understanding Collections
• Using the Object Browser
• Working with Properties
• Using the With Statement
• Working with Methods
• Creating an Event Procedure

4. Using Expressions, Variables and Intrinsic functions
• Understanding Expressions and statements
• Declaring Variables
• Understanding Data types
• Working with Variable Scope
• Using Intrinsic Functions
• Understanding Constants
• Using intrinsic Constants
• Using Message Boxes
• Using Input Boxes
• Declaring and Using Object Variables

5. Controlling Program Execution
• Understanding Control-of-Flow Structures
• Working with Boolean Expressions
• Using the If..End If Decision Structures
• Using the Select Case ..End Select Structure
• Using the Do..Loop Structure
• Using the For..To..Next Structure
• Using the For Each ..Next Structure
• Guidelines for use of Control-of-Flow Structures

6. Working with Forms and Controls
• Understanding UserForms
• Using the Toolbox
• Working with the UserForm Properties, Events, and Methods
• Understanding Controls
• Setting Control Properties in the Properties Window
• Working with the Label Control
• Working with the TextBox Control
• Working with the Command Button Control
• Working with the Combo Box Control
• Working with the Frame Control
• Working with Option Button Controls
• Working with Control Appearance
• Setting the Tab Order
• Populating a Control
• Adding Code to Controls
• Launching a Form in Code

7. Working with the PivotTable Object
• Understanding PivotTables
• Creating a PivotTable using Worksheet Data
• Working with Pivot Objects
• Working with the PivotFields Collection
• Assigning a Macro to the Quick Access Toolbar

8. Debugging Code
• Understanding Errors
• Using Debugging Tools
• Setting Breakpoints
• Stepping through Code
• Using Break Mode during Run mode
• Determining the value of Expressions

9. Handling Errors
• Understanding Error Handling
• Understanding VBA’s Error Trapping Options
• Trapping Errors with the On Error statements
• Understanding the Err Object
• Writing an Error-Handling Routine
• Working with Inline Error Handling

10. 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


Al fees subjec to GST 7%.
Course Fees (Applicable to Non-NICF/Foreigner)
Course Title Normal Course Fees Promotional Course
Fees valid till
31-Dec-2017
Promo Course Fees w GST
NICF - VBA Excel S$999.00S$740.00S$791.80
Registration FeeS$30.00S$30.00S$32.10
Total FeeS$1,029.00S$770.00S$823.90

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
NICF - VBA Excel SingaporeRegisterFULL-TIME7-Nov-201710-Nov-20179:30AM-5:30PM 
NICF - VBA Excel SingaporeRegisterFULL-TIME4-Dec-20177-Dec-20179:30AM-5:30PM 
NICF - VBA Excel SingaporeRegisterFULL-TIME8-Jan-201811-Jan-20189:30AM-5:30PM 
NICF - VBA Excel SingaporeRegisterFULL-TIME1-Feb-20186-Feb-20189:30AM-5:30PM 
NICF - VBA Excel SingaporeRegisterFULL-TIME5-Mar-20188-Mar-20189:30AM-5:30PM 
NICF - VBA Excel SingaporeRegisterSAT4-Nov-201725-Nov-20179:30AM-5:30PM 
NICF - VBA Excel SingaporeRegisterSAT13-Jan-20183-Feb-20189:30AM-5:30PM 
NICF - VBA Excel SingaporeRegisterSAT7-Apr-201828-Apr-20189:30AM-5:30PM 

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