Vision & Mission
Upcoming Events
MEFA Monthly Calendar
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
Data Management with PivotTable using Microsoft Excel
 
Objectives

• Applying and optimizing an intelligent, flexible and interactive PivotTable in analyzing and reporting on frequently changing of mass data
• Leveraging on PivotChart 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

 
Topics Covered
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.
 
Target Audience

​Excel Power user

 
Methodology
  • Lecture
  • Demonstration

 

 
Scheme SBL Fee RM561.80
Duration 7 Hours Members Less -