Excel VBA Macro Software Design
23+
Years
120+
Courses
3,460+
Corporate Clients
45,000+
People Trained
Trusted by
WSQ Accredited · Intellisoft
Next Available Date
Next Class
⚡ 15, 16, 17 Apr 2026
Course Details
Duration
3 Days (9am–5pm)
Venue
Fortune Centre, Singapore
Class Size
Up to 15 Pax
Certificate
✓ WSQ Certificate Issued
Accreditation
TSC Code
ICT-DES-3005-1.1
Full fee: S$1,046.40 incl. 9% GST · See grant table →
WSQ & SkillsFuture funding available — view full grant breakdown →
✓ 100% satisfaction guarantee · Respond within 2 hours
About This Course
About This Excel VBA Macro Software Design Course
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.
Learn By Doing
Hands-on exercises on real Singapore business datasets from the very first module.
Small Class Sizes
Capped at 15–20 participants for personal attention.
Post-Training Support
30-day free email support after the course to training@intellisoft.com.sg.
What You Will Learn
What You Will Learn in Excel VBA Macro Software Design
Is This For You?
Who Should Attend Excel VBA Macro Software Design?
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:
- 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.
- 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.
- 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.
- 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.
Before You Attend
Pre-Requisites for Excel VBA Macro Software Design
The prerequisites for joining our VBA macro programming workshop are:
- 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.
- Access to Excel: Participants should have access to a version of Excel that supports VBA programming, such as Excel 2013 or later.
- Willingness to learn: Participants should be motivated and willing to learn new skills and concepts related to VBA programming.
Curriculum
Excel VBA Macro Software Design: Course Outline & Curriculum
Lesson 1: Software Design With Macros
TOPIC A: Getting to Know Excel Macros
- Visual Basic for Applications
- Macros
- Object-Oriented Programming
- Macro Options
- Activity: Getting to Know Macros
TOPIC B: Creating a Macro in Microsoft Excel
- 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: Editing an Excel 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: Debugging a Macro in Excel
- The Debugging Process
- Debugging Tools
- How to Debug a Macro
- Activity: Debugging a Macro
TOPIC E: Customizing 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: Setting Macro Security in Excel
- Digital Certificates
- Digital Signatures
- Macro Security Settings
- Activity: Setting Macro Security
Summary
Review Questions
Lesson 2: Formatting Worksheets Using Macros
TOPIC A: Inserting Text With Excel Macros
- The Selection Property
- The ActiveSheet Property
- The Name Property
- The Value Property
- Concatenation
- How to Insert Text
- Activity: Inserting Text
TOPIC B: Formatting Text with Macros in Excel
- How to Format Text
- Activity: Formatting Text
TOPIC C: Sorting Data within Excel
- The Range Object
- The Select Method
- The CurrentRegion Property
- How to Sort Data
- Activity: Sorting Data
TOPIC D: How To Duplicate Data With Excel Macros
- 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 in Excel Using Macros
- 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
Summary
Review Questions
Lesson 3: Creating an Interactive Worksheet with Excel Macros
TOPIC A: Determining the Dialog Box Type
- Message Boxes
- Input Boxes
- Activity: Determining the Dialog Box Type
TOPIC B: Capturing User Input With Macros
- 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
Summary
Review Questions
Lesson 4: Working with Multiple Worksheets
TOPIC A: Insert, Copy, and Delete Worksheets With Excel Macros Methods
- The Add Method
- The Copy Method
- The Delete Method
- How to Insert, Copy, and Delete Worksheets
- Activity: Inserting and Deleting Worksheets
TOPIC B: Renaming Worksheets Within Excel
- Expressions
- The DateSerial Function
- The Format Function
- How to Rename Worksheets
- Activity: Renaming Worksheets
TOPIC C: Modify the Order of Worksheets Easily With Excel Macros
- 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
Summary
Review Questions
Lesson 5: Performing Calculations With Excel Macro Code
TOPIC A: Create User-Defined Functions inside Excel
- 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
Summary
Review Questions
Your Trainer
👤
Trusted by professionals from 500+ organisations
Training Course Fees & Funding
Full course fee: S$960.00 (before GST & government funding) TGS: TGS-2022016805
Highest Funding
70%
Grant
70% SSG Grant
Baseline + Enhanced Training Support
- SG Citizens aged 40+ (Individual, SME or MNC)
- SME-sponsored SG Citizens (21+)
- SME-sponsored PRs (21+)
Course Fee
S$960.00
SSG Funding (70%)
− S$672.00
Nett Fee
S$288.00
GST (9%)
S$86.40
You Pay
S$374.40
SSG Funded
50%
Grant
50% SSG Grant
Baseline WSQ Funding
- SG Citizens aged 21–39 (Individual or MNC)
- MNC company-sponsored PRs (21+)
- Individual PRs (21+)
Course Fee
S$960.00
SSG Funding (50%)
− S$480.00
Nett Fee
S$480.00
GST (9%)
S$86.40
You Pay
S$566.40
Foreigners & other pass holders: Government grants are not applicable. Full course fee of S$960.00 + 9% GST = S$1,046.40 applies. Contact us for more details.
Additional Funding Options
SkillsFuture Credit
Singapore Citizens aged 25+ can use their SkillsFuture Credits to offset nett fees.
SFEC (Enterprise Credit)
Companies sending local & foreign staff can claim up to $10,000 SFEC funding.
UTAP (NTUC Members)
NTUC members can claim up to 50% of remaining fees (capped at $500/year).*
Need help with funding applications? We'll guide you through the process.
* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Apr 2026.
Register
Register for Excel VBA Macro Software Design in Singapore
| Date | Duration | Venue | |
|---|---|---|---|
15, 16, 17 Apr 2026 |
3 Days (9am–5pm) | Fortune Centre, Singapore | Register → |
11, 12, 13 May 2026 |
3 Days (9am–5pm) | Fortune Centre, Singapore | Register → |
17, 18, 19 Jun 2026 |
3 Days (9am–5pm) | Fortune Centre, Singapore | Register → |
14, 15, 16 Dec 2026 |
3 Days (9am–5pm) | Fortune Centre, Singapore | Register → |
🏢 Running this for a group? Request a Custom Corporate Run →
Ready to Get Started?
Upgrade Your Skills.
Seats Fill Quickly.
Join thousands of professionals who've trained with Intellisoft. With WSQ funding, this is the most cost-effective way to upskill your team.
💬 Quick Enquiry
✅ Thank you! We'll be in touch shortly.