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

Tel: 603-7955 7778
Fax: 603-7955 1945
Upcoming Trainings & Events
Microsoft Excel (Advanced) – Manipulating Data EffectivelyMidvalley City, KL 27-28 Aug 2019
Download Registration Form
In this course, participants will learn the practical techniques to manage/analyse your data efficiently and at ease. Participants will apply and optimize Excel’s powerful functions and formulas at work. Through intensive hands-on exercise, participants will learn to clean, organize, filter, summarize and manage data. This course will also enable participants to simplify and automate repetitive tasks with Microsoft Excel Macro/VBA.
  • Apply the best practices of data import options to Extract, Transfer, Import/Export data and text files from worksheet, files, software & other programs.
  • Apply techniques in cleaning up large volume of data: remove and rearranging duplicate rows/columns, spaces, fixing time, date and numbers.
  • Manage, organize and summarize data in a particular order based on your criteria with the Sort and Subtotal features.
  • Select and filter the data to view and set criteria to extract data that you intend to analyse using the View, Auto Filter and Advanced Filter functions.
  • Structure and Present data impressively using Excel Tables.
  • Match and reconcile your data using the Vlookup Functions.
  • Leverage on Excel critical formulas in enhancing work efficiency-If/Nested If, And/Or, Count/Counta, Countif, Sumif/Average Ifs
  • Learn the basics of Excel Macro
Topics Covered
Target Audience
Scheme SBL Fee RM477
Duration 14 Hours Members Less
This course will also be conducted at the following dates/venues
15-16 October 2019Midvalley City, KLmore details  >>
There are currently no events scheduled for other dates or venues.