Excel VBA Software Design: WSQ Funded VBA Course

WSQ Excel VBA Course in Singapore at Intellisoft Systems

Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achieve More. Save time.

What Will You Learn?

  • Enhance your current Excel files & automate your work with VBA Macros & Code.
  • Master Excel VBA & Macros
  • Directly apply the Excel VBA samples included in your own work.
  • Reduce manual routine tasks to the click of a button.
  • Make your work life easier.
  • Create simple solutions to complex problems by levering Excel functionality with Macros.
  • Formulas & Excel core functionality can’t do everything. Use VBA when you reach a limitation.
  • Utilize the objects in the Excel Object Model to emulate user actions in Excel
  • React dynamically to user events like entering a cell value or opening a workbook
  • Feel comfortable with the fundamentals of computer programming

Highly Trusted & Quality WSQ VBA Course in Singapore at Intellisoft

Course Overview

Excel VBA Macros programming language allows users to do amazing stuff with Excel. They enjoy working at higher speeds and get tedious Microsoft Excel tasks done in mere seconds, completing intricate calculations accurately.

VBA is a flexible language, and its English-like syntax makes learning easy.  VBA code saves time and increases accuracy by automating the routine and keeping things running at high accuracy and efficiency.

VBA is also one of the easiest ways to automate processes. It doesn’t require installing anything on the client’s computer with Excel. By writing the VBA code, employees increase their productivity and make themselves more valuable to current and future employers.

For tasks like data consolidation, data analysis,  forecasting, or reporting, users can effectively automate a large portion of their work in areas such as Finance, Banking, Healthcare, Customer Service, and Management Reporting.

Learning Forms and Controls helps users to build User Interactive Windows or Forms, including getting the data from various sources and interacting with other applications.

In addition, VBA can automate most tasks, including report generation, creating a spreadsheet, calculating a large amount of data, and performing data analysis.

Course Outline

Course outline for  3-day Excel VBA Software Design & Programming course:

Lesson 1: Developing Macros

TOPIC A: Get to Know Macros
  • Visual Basic for Applications
  • Macros
  • Object-Oriented Programming
  • Macro Options
  • Activity: Getting to Know Macros
TOPIC B: Create a Macro
  • The Macro Recorder
  • Personal Macro Workbooks
  • How to Create a Macro Using the Macro Recorder
  • Activity: Creating a Macro Using the Macro Recorder
TOPIC C: Edit a Macro
  • The Visual Basic Editor
  • Projects
  • Modules
  • The Modules Folder
  • Objects
  • Properties
  • Methods
  • VBA Comments
  • How to Edit a Macro
  • Activity: Editing a Macro
TOPIC D: Debug a Macro
  • The Debugging Process
  • Debugging Tools
  • How to Debug a Macro
  • Activity: Debugging a Macro
TOPIC E: Customize the Quick Access Toolbar and Hotkeys
  • Add a Button to the Quick Access Toolbar to Run a Macro
  • Assign a Keyboard Shortcut to a Macro
  • Activity: Customizing the Quick Access Toolbar and Hotkeys
TOPIC F: Set Macro Security
  • Digital Certificates
  • Digital Signatures
  • Macro Security Settings
  • Activity: Setting Macro Security

Lesson 2: Formatting Worksheets Using Macros

TOPIC A: Insert Text
  • The Selection Property
  • The ActiveSheet Property
  • The Name Property
  • The Value Property
  • Concatenation
  • How to Insert Text
  • Activity: Inserting Text
TOPIC B: Format Text
  • How to Format Text
  • Activity: Formatting Text
TOPIC C: Sort Data
  • The Range Object
  • The Select Method
  • The CurrentRegion Property
  • How to Sort Data
  • Activity: Sorting Data
TOPIC D: Duplicate Data
  • Data Types
  • Variables
  • Variable Naming Rules
  • Operators
  • The Assignment Operator
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • The For Next Loop
  • Do Loops
  • The Worksheets Object
  • The Count Property
  • The Offset Property
  • The Copy Method
  • The Paste Method
  • How to Duplicate Data
  • Activity: Duplicating Data
TOPIC E: Generate a Report
  • The Columns Property
  • The AutoFit Method
  • The Address Property
  • The Call Statement
  • The Font Property
  • The End Property
  • How to Generate a Report
  • Activity: Generating a Report

Lesson 3: Creating an Interactive Worksheet

TOPIC A: Determine the Dialog Box Type
  • Message Boxes
  • Input Boxes
  • Activity: Determining the Dialog Box Type
TOPIC B: Capture User Input
  • The InputBox Function
  • Constants
  • The MsgBox Function
  • The Code Continuation Character
  • The vbCrLf Constant
  • Decision Structures
  • The Select Case Statement
  • The If Then Structure
  • The Else Clause
  • How to Capture User Input
  • Activity: Capturing User Input

Lesson 4: Working with Multiple Worksheets

TOPIC A: Insert, Copy, and Delete Worksheets
  • The Add Method
  • The Copy Method
  • The Delete Method
  • How to Insert, Copy, and Delete Worksheets
  • Activity: Inserting and Deleting Worksheets
TOPIC B: Rename Worksheets
  • Expressions
  • The DateSerial Function
  • The Format Function
  • How to Rename Worksheets
  • Activity: Renaming Worksheets
TOPIC C: Modify the Order of Worksheets
  • The Move Method
  • How to Modify the Order of Worksheets
  • Activity: Moving Worksheets within a Workbook
  • TOPIC D: Print Worksheets
  • The PrintPreview Method
  • The PrintOut Method
  • How to Print Worksheets
  • Activity: Printing a Workbook

Lesson 5: Performing Calculations

TOPIC A: Create User-Defined Functions
  • User-Defined Functions
  • Types of Functions
  • Arguments
  • How to Create User-Defined Functions
  • Activity: Creating and Applying a User-Defined Function
TOPIC B: Automate SUM Functions
  • Declared Range Objects
  • The Set Statement
  • Range Object Cell Addressing
  • The Rows Property
  • The Formula Property
  • The Columns Property
  • Address Property Cell Reference Settings
  • How to Automate SUM Functions
  • Activity: Automating SUM Functions

Target Audience

The target audience for an Excel VBA macro programming class includes individuals who want to automate tasks, streamline workflows, and create custom solutions using Excel. This can include:

  1. Business professionals: Individuals who work with Excel regularly, such as financial analysts, project managers, or administrative assistants, can benefit from learning VBA to automate repetitive tasks and create customized reports.
  2. Programmers and developers: Individuals who have experience with programming languages such as Java or Python can use VBA to extend the functionality of Excel and create custom add-ins that interact with other applications.
  3. Students: Students who are studying business, finance, or data analysis can benefit from learning VBA as it is a valuable skill in many industries and can help them stand out in the job market.
  4. Excel power users: Individuals who already have advanced knowledge of Excel and want to take their skills to the next level can benefit from learning VBA to create more complex solutions and automate advanced tasks.

Overall, anyone who uses Excel frequently and wants to increase their productivity, efficiency, and accuracy can benefit from learning VBA macro programming.

Pre-Requisites

The prerequisites for joining our VBA macro programming workshop are:

  1. Basic knowledge of Excel: Participants should have a good understanding of Excel’s features, such as creating and formatting worksheets, entering data, and using basic formulas and functions.
  2. Access to Excel: Participants should have access to a version of Excel that supports VBA programming, such as Excel 2013 or later.
  3. Willingness to Learn: Participants should be motivated and willing to learn new skills and concepts related to VBA programming.

Grant Information

WSQ: To claim up to 70% of WSQ Funding for this Excel VBA Software Design course,  participants must be Singaporeans or PRs. They can be individual or COMPANY SPONSORED. We will apply for the WSQ Grant on your behalf AFTER you successfully register for this training. SSG Terms and Conditions apply for WSQ Funding based on your/your company’s eligibility.

SkillsFuture for Microsoft Excel Training: Individual Singaporeans aged 25 and above can use their SkillsFuture Credits for this WSQ Excel VBA Macros training class.

UTAP Funding: NTUC Members can utilize UTAP to offset 50% of the remaining fees*.

Call us at +65 6250-3575 or email training@intellisoft.com.sg for any questions or to register for the upcoming class of WSQ Excel VBA Macro Course with Skillsfuture & WSQ funding from SSG.

Training Course Fees

The full course fees for this training is S$960, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6252-5033 for Details or WhatsApp Now at +65-9066-9991

up to 70% Grant

$672 Funding by SSG
Pay $288
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

up to 50% Grant

$480 Funding by SSG
Pay $480
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

Do You Have Any Questions

on Course Fee, WSQ Grant or Funding?

Ask Us. We’ll be happy to assist you.
Training Schedule

Register

How To Register For Excel VBA Software Design Course in Singapore

Register for the Best 3 Days Excel VBA Macro  Course in Singapore today by simply clicking on the chosen course date available at the top of this page.

Need Help?
Call us at +65-6250-3575, SMS / WhatsApp: 9066-9991

Send an email to training@intellisoft.com.sg

We have regular public classes For Excel VBA Programming training each month, and Corporate Training can be arranged at your office too!

Infographic of Financial Reports

Note: This class uses a convenient and hands-on approach to gain Excel VBA  Mastery. It requires you to take part in VBA programming exercises during the class. You can bring your own laptop or request to use our computer during the class beforehand.

WSQ Funded Excel VBA Training:

Join today, and begin to Master Excel VBA coding with our step-by-step instructions and helpful, patient Microsoft Certified Trainers to guide you.

What are you waiting for? Get Started Right away…

Why Choose Us?

ACTA Certified Trainers

Authorized Training Organization

WSQ
Certifications

Fully Set Up
Training Room

20+ Years
Experience in Education

Practical, Hands-on
Training

25,000+
Certified Students

32+
Courses

Useful & Handy
Student Guide

Contact Us

LOCATION: Fortune Centre, 190 Middle Road, Singapore

COURSE DURATION: 3 full days (Weekdays or Weekends)

COURSE TIMING: 8:45 am to 5:45 pm

Start Saving Today

Get the 8 Tips to Start Saving on Your Website Design
PDF Guide emailed to you now.

Save Money on Website Design Guide