Vision & Mission
Upcoming Events
Training Programs
 
Industrial Relations
HR Management
& Development
Occupational Safety
& Health
Business Management
ICT
Certification &
Academic Courses
SWINBURNE
Certified Programs
UNIMAS
Certified Programs
In-house Courses
PSMB Scheme
Academy Staff
Contact Us
 
Training Directory 2024
 
MEF ACADEMY
3A06-3A07, Block A,
Phileo Damansara II,
No. 15 Jalan 16/11, Seksyen 16,
46350 Petaling Jaya,
Selangor Darul Ehsan,
Malaysia

Tel: 603-7498 7200

 
 
Information & Communication Technology
Tasks Automation with Microsoft Excel Macro/VBA
 
Objectives
 
Topics Covered
Working with VBA
Learn the ease of creating simple macro using recording.
Discover the advantages on how VBA can help to simplify workbook tasks.
 
The Basics of VBA
Identify the way around the Visual Basic Application (VBA) windows.
Learn the workflow processes for automation and the VBA environment.
Familiarize the concepts of VBA syntax and its environment. Learn to read and understand the meaning of the syntax.
 
Variables
Expose to variables. Learn the rope to flexibilities in coding.
 
Control Structures
Learn the technique of coding and explore the If Then Else structures and how to make codes to be repeated using structures such as For Next and Do Loops.
 
Target Audience

​This course is relevant for Excel users who perform their tasks repetitively at work. No prior knowledge of Excel Macro/VBA is required.

 
Methodology
 
Scheme SBL Fee RM 1007
Duration 14 Hours Members Less -