breakthrough Performance For HR In Excel

Course details

Human Resources Managers and Executives who have to regularly prepare reports related to employees leave, training, payroll, etc , using data downloaded from systems. They are required to know how to format cells, auto-filter, sort, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.

Learning Objectives

Upon completion of the course, participants will be able to:

• Prepare HR reports in double quick time and respond to business needs with relevance.
• Transform data from standard HR systems into meaningful and robust reports for management.

Course Outline

• How to effectively calculate overtime hours using Excel
• Track expiry of work permits and passports using conditional formatting
• Identify the oldest employees at a glance using conditional formatting
• How to profile employees using Pivot Table, Age formula
• How to monitor training cost spending against training budgets using formulas
• Monitor training hours clocked by employees, job grade, department, etc
• Create a job application form and capture the details to facilitate screening of job applicants using Excel forms
• Compare last month report with current month report using VLOOKUP and conditional formatting
• How to swop first name and last name and vice versa
• Combine first and last names into one cell
• Display the zeros in front of employee IDs