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

 
 
Upcoming Trainings & Events
 
[IT] Data Management with Pivot Table using Microsoft Excel Online Learning – Microsoft Teams 12 June 2024; 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
 
COURSE OUTLINE
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.