
- Quick Links
- Course Lists
Cisco Certifications
Cloud Computing
- CompTIA Network+
- CompTIA Security+
- CompTIA CySA+
- CompTIA Cloud Essentials
- CompTIA Server+
- CompTIA Linux+
CompTIA Certifications
- Certified Ethical Hacker CEH
- Cert Incident Handler ECIH
- CCNA Security
- CompTIA Security+
- CompTIA CySA+
IT & Cyber Security
Database & Programming Course
Mobile App Programming
- Apple iOS App Programming
- Developing Android Apps
- Java Programming for Android
- Monetize Android Applications
- Android Security Essentials
- NICF - Intro to Networking
- IPv6 Fundamentals
Basic Networking
Microsoft Certifications- MCSA Windows Server 2012
- MCSE Windows Server 2012
- MS SQL Server 2012 - Database Administration
- MS SQL Server 2012 - Database Querying
Web Design & E-Commerce
- All-in-One Web Design
- Advanced Web Design
(HTML5+JavaScript+CSS3) - Adobe Dreamweaver CS6
- Adobe Photoshop CS6
- Create Beautiful Web Design Using Wordpress
- Ecommerce - Set up Shopping Cart
SkillsFuture Courses
- Course Schedule
- Course Registration
- About Us
Home > Course List > VBA for Excel 2010/2013/2016 VBA Excel Course Singapore - VBA Excel 2013/2016 (NICF - VBA Excel)
Course Objective: This 3-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 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 participants completing the course achieving minimum 75% attendance.
Training Duration: Full-time: 3 Weekdays / 3 Sats
Time : 9.00am - 6.00pm (24hrs)
Course is eligible for SDF Training Grant and Absentee Payroll.
Self-sponsored trainees may apply for SkillsFuture Credit Claim.
Terms and conditions applyCourse 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 Security2. 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 Editor3. 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 Procedure4. 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 Variables5. 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 Structures6. 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 Code7. Debugging Code
• Understanding Errors
• Using Debugging Tools
• Setting Breakpoints
• Stepping through Code
• Using Break Mode during Run mode
• Determining the value of Expressions8. 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 Handling9. 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-SDF/Foreigner) Course Title Normal Course Fees Promotional Course
Fees valid till
31-Jul-2021Promo Course Fees w GST NICF - VBA Excel S$799.00 S$650.00 S$695.50 Registration Fee S$30.00 S$30.00 S$32.10 Total Fee S$829.00 S$680.00 S$727.60
Government Funding
Course is eligble for SDF Training Grant & Absentee Payroll from SSG.
Self-Sponsored trainee may offset course fee payable using their SkillsFuture Credit Claim or/& PSEA (subject to available balance in trainee's account).
Terms and conditions apply.
SDF Course Title : VBA Excel (SF)
Course Ref No. : CRS-Q-0032182-ICT
WSQ Funding Course Fees WSQ Funding
Singapore Citizens & Singapore PRsTotal Fee
Incl Regn FeeLess
SDF Training
GrantNETT
Fee
Excl GST 7%NETT
Fee
Incl GST 7%SME Company S$680.00 S$585.00 S$95.00 S$142.60 Non-SME Company S$680.00 S$325.00 S$355.00 S$402.60 Self-Sponsored S$680.00 S$325.00 S$355.00 S$402.60* Mid-Career Enhanced Scheme (MCES)
- Singaporean, 40 yrs & aboveS$680.00 S$585.00 S$95.00 S$142.60* Workfare Trainig Support(WTS) S$680.00 S$617.50 S$62.50 S$110.10* Note: * - SkillsFuture Credit Claims or/and PSEA may be used to offset the course fees.
Course Title Venue Register Online Course ModeStart DateEnd DateTimeNICF - VBA Excel Singapore Register FULL-TIME 1-Feb-2021 3-Feb-2021 9:00-6:00PM NICF - VBA Excel Singapore Register FULL-TIME 10-Mar-2021 12-Mar-2021 9:00-6:00PM NICF - VBA Excel Singapore Register FULL-TIME 5-Apr-2021 7-Apr-2021 9:00-6:00PM NICF - VBA Excel Singapore Register FULL-TIME 19-May-2021 21-May-2021 9:00-6:00PM NICF - VBA Excel Singapore Register FULL-TIME 23-Jun-2021 25-Jun-2021 9:00-6:00PM NICF - VBA Excel Singapore Register FULL-TIME 14-Jul-2021 16-Jul-2021 9:00-6:00PM NICF - VBA Excel Singapore Register FULL-TIME 2-Aug-2021 4-Aug-2021 9:00-6:00PM NICF - VBA Excel Singapore Register FULL-TIME 1-Sep-2021 3-Sep-2021 9:00-6:00PM NICF - VBA Excel Singapore Register FULL-TIME 11-Oct-2021 13-Oct-2021 9:00-6:00PM NICF - VBA Excel Singapore Register FULL-TIME 17-Nov-2021 19-Nov-2021 9:00-6:00PM NICF - VBA Excel Singapore Register FULL-TIME 8-Dec-2021 10-Dec-2021 9:00-6:00PM NICF - VBA Excel Singapore Register SAT 10-Apr-2021 24-Apr-2021 9:00-6:00PM NICF - VBA Excel Singapore Register SAT 10-Jul-2021 24-Jul-2021 9:00-6:00PM NICF - VBA Excel Singapore Register SAT 9-Oct-2021 23-Oct-2021 9:00-6:00PM
Download VBA Excel Course Brochure
Download Advanced VBA Excel Course Brochure (Contact Customer Service @ 6333 4843)
Copyright © 2008
IT Enabler Consultancy Pte Ltd
(BRN/GST No: 200211025Z)
Address:
35 Selegie Road
Parklane Shopping Mall #09-06
Singapore 188307
Telephone:
6333 4843
Fax No:
6333 4883
Email : customerservice@ienabler.com.sg