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