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 2021
 
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-7955 7778
Fax: 603-7955 1945
 
 
Upcoming Trainings & Events
 
Tasks Automation with Microsoft Excel Macro/VBATraining will be conducted on face-to-face or On-Line 3-4 March 2021, 12-13 April 2021
Download Registration Form
 
Fee: RM1007 per pax
Fee is inclusive of SST
 
One of Microsoft Excel’s most powerful capabilities for heavy users is the Visual basic Application (VBA) language. Learning its capabilities is an enormous benefit in almost any field and at all levels of experience.Repetitive tasks can be quickly automated with the Microsoft Excel Macro/VBA. It can be used for various tasks e.g. communicating with databases, analyzing data, automating worksheet construction, modeling and simulation, creating charts/graphs, creating wizards (i.e. dialog boxes), creating graphic user interfaces GUI) and many more.
 
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.
 
This course will also be conducted at the following dates/venues
 
There are currently no events scheduled for other dates or venues.