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] PowerPivot: Powerful Data Analysis and Data Modelling in Microsoft Excel Online Learning – Microsoft Teams 12-13 December 2023 (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.
 
COURSE OUTLINE
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.