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

 
 
Upcoming Trainings & Events
 
[IT] PowerPivot: Powerful Data Analysis and Data Modeling in Microsoft Excel Online Learning – Microsoft Teams 12-13 December 2024 (9.00 AM – 5.00 PM)
Download Registration Form
 
Objectives

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.

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

​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.

 
Methodology

 

 
Scheme SBL Fee RM 1, 400
Duration 14 Hours Members Less
 
This course will also be conducted at the following dates/venues
 
There are currently no events scheduled for other dates or venues.