Task Automation with Macros, VBA and AI Co-Pilots

Training Provider: SINGAPORE MANAGEMENT UNIVERSITY
Course Reference: TGS-2025058336
S$800
Original: S$1,600
Save S$800

About This Course

This module will explore the use of Macros, Visual Basic for Applications (VBA), and Solver within Microsoft Excel to perform a range of task automations in the context of a business intelligence solution. The objective will be to develop an understanding of how these tools may be applied, and a capability to apply them in a set of fundamental use cases.

What You'll Learn

At the end of the 2-day module, participants will be able to:
• Apply Macros - recording and managing macros, alongside use cases
• Design, implement and manage simple Visual Basic for Applications (VBA) scripts
• Using Solver to optimise decision making
• Explore the use of Marcos, VBA, and Solver within Microsoft Excel to perform a range of task automation in the context of business intelligence solution

Entry Requirements

Participants with at least a diploma qualification

Course Details

Duration 15 hours
Language English
Training Commitment Part Time
Total Enrolled 16 students
Back to All Courses
Note: To apply for this course, visit or contact the training provider directly.

More Courses from SINGAPORE MANAGEMENT UNIVERSITY

In today's digital-first world, the demand for skilled cybersecurity professionals has never been hi...
Duration 392 hours
Fee After Subsidy S$10,584
This certificate programme is designed for non-technical professionals who want to develop data visu...
Duration 330 hours
Fee After Subsidy S$5,760
The (SCTP) Advanced Certificate in Digital Marketing programme provides a comprehensive and immersiv...
Duration 128 hours
Fee After Subsidy S$5,760