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] HR Dashboard Analytics Online Learning – Microsoft Teams 22-23 July 2024 (9.00 AM – 5.00 PM)
Download Registration Form
 
Course Fee
RM 1,400 (inclusive SST) per participant


Dashboards have increasingly become an essential need in enhancing decision making.
This course gets HR Professionals to the forefront in the technology on visual display of data to enhance HR reporting, analysis and performance management. As a visual display tool of key HR metrics, dashboards simplify information gathering and present data in a way that can be sorted, analyzed and presented in a focused, clear and engaging manner in an organization. Using scenarios, this course will enable participants to learn, plan, structure, organize and eventually develop a comprehensive HR Dashboard.
 
This course will explore the dynamics of Pivot Table and Pivot Charts and will also apply the tips and tricks on using Pivot Table in HR Dashboards. Participants will also learn to apply the powerful combination of excel formulas to determine how they can produce a HR Dashboard that best fit organizational goals.
 
COURSE OUTLINE
Module 1: Pivot Table and Pivot Chart in HR Dashboard
Module 2: Creating Pivot Table from multiple sources
Module 3: Interactive Filter Control on HR Dashboard using Slicer
Module 4: Leveraging the relevant formulas to calculate and summarize data
Module 5: Selecting Grouping Categories in a Pivot Table
Module 8: Developing a Training Dashboard (Scenario 2)
Module 9: Constructing a Comprehensive HR Dashboard (Scenario 3)
 
*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.