Vision & Mission
Upcoming Events
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] PowerPivot: Powerful Data Analysis and Data Modelling in Microsoft ExcelOnline Learning – Microsoft Teams 23-24 May 2024 (9.00 AM – 5.00 PM)
Download Registration Form
Course Fee
RM 1, 400 (inclusive SST) per participant

With PowerPivot, Microsoft brings the dynamism of Business Intelligence tools to Excel, transforming enormous number of data/records into meaningful information. It is a Big Data tool that helps to generate rich and interactive analytics solutions.
Who Should Attend
This course is relevant to data analysts, business analysts, financial analysts and anyone who wants to better manage their data. Knowledge and experience in using Excel PivotTable is assumed. Participants are required to have the Microsoft Excel version 2010 and above.
Module 1: Introduction to PowerPivot
Module 2: Getting Data into PowerPivot
Module 3: Table Relationships
Module 4: PowerPivot Windows
Module 5: Calculated Column
Module 6: PivotTables
Module 7: PowerPivot and Dashboards
Module 8: Create simple Data Analysis Expression (DAX) and Key Performance Indicators (KPI)
Module 9: Create a Hierarchy in a Table
Module 10: Create and Manage Data with Perspectives
*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.