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

Tel: 603-7498 7200

Upcoming Trainings & Events
[IT] Data Management with Pivot Table using Microsoft Excel Online Learning – Microsoft Teams 17 July 2024 (9.00 AM – 5.00 PM)
Download Registration Form
Course Fee
RM 561.80 (inclusive SST) per participant

What is PivotTable?
PivotTable is a powerful data analysis tool, yet most Excel users do not use it to its fullest potential. This course shows you why PivotTable is so versatile for data analysis and how you can leverage PivotTable to rapidly analyze, sort, filter, spot trends and make business decisions from masses of data.
In this course you will learn to:
• Applying and optimizing an intelligent, flexible and interactive PivotTable in analyzing and reporting on frequently changing of mass data
• Leveraging on Pivo Chart to visually represent PivotTable data
• Summarizing datasets with grouping and aggregation
• Flipping your data into alternate views and slicing and dicing it for deeper mining
• Creating Interactive Dashboard with PivotTable and PivotChart
Module 1: Introduction to PivotTable
Module 2: Setting your Data Right
Module 3: Creating a PivotTable
Module 4: Optimizing on the features of Slicers
Module 5: Customizing a PivotTable and the Fields
Module 6: Investigating Your Data with PivotTable
Module 7: Analysis with PivotTable Grouping
Module 8: Performing Calculation within PivotTable
Module 9: Interpreting data with PivotCharts
Module 10: Analyzing Multiple Data Sources
Module 11: Creating Interactive Dashboard with PivotTable and PivotChart
*For more information, please click and refer to the brochure
This course will also be conducted at the following dates/venues
There are currently no events scheduled for other dates or venues.