TSY In House Training #918: Task Automation With Excel Macro

7 days ago

1 min read

TSY In House Training #918: Task Automation With Excel Macro — Training ongoing.

This two days course covers the fundamental of Visual Basic programming codes to customize the Excel Macros.

During in-class hands-on exercise, you will be able to customize and enhance your Excel Macro program using the programming skills in VBA (Visual Basic for Applications).

Date: 17th & 18th September 2026

Client: NationGate Solution (M) Sdn. Bhd., Prai, Penang

Course Objectives:

By the end of the course, participant will be able to:

using variables in VBA coding.
using conditional and logical operators in VBA coding.
use conditional statements and loops to control VBA code execution.
code and call a Sub Procedure.
code the error handling.
use the build-in functions (String functions, date functions, time functions).
create simple UserForm.

Pre-requisites:

Participant must have attended the TASK AUTOMATION WITH EXCEL MACRO/VBA (Level 1 / Basic) course or basic knowledge in Excel Macro/VBA

Who Should Attend:

You must be an Experienced Excel user (non-Technical Users) who wish to automate repetitive tasks or simplify more complex tasks using Excel Macros and VBA (Visual Basic for Applications) programming language.

Training Methodology:

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.

More Training Pictures: