Breakthrough Performance for HR in Excel – Based on Excel 2007/10
Powerful Data Management and Reporting for Human Resources.
In-House sessions are available upon request.
This solution-based Microsoft® Excel course is tailored for human resources personnel who are seeking increase in productivity and improving their HR operation processes such as the tracking of work permits and passports renewal for foreign workers, tracking of training budgets, analysis of staff cost, short listing of job applicants, etc.
Who Should Attend:
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.
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.
|Section 1: How to effectively calculate overtime hours using Excel|
|Section 2: Track expiry of work permits and passports using conditional formatting|
|Section 3: Identify the oldest employees at a glance using conditional formatting|
|Section 4: How to profile employees using Pivot Table, Age formula|
|Section 5: How to monitor training cost spending against training budgets using formulas|
|Section 6: Monitor training hours clocked by employees, job grade, department, etc|
|Section 7: Create a job application form and capture the details to facilitate screening of job applicants using Excel forms|
|Section 8: Compare last month report with current month report using VLOOKUP and conditional formatting|
|Section 9: How to swop first name and last name and vice versa|
|Section 10: Combine first and last names into one cell|
|Section 11: Display the zeros in front of employee IDs|
|Breakthrough Performance for HR in Excel – Based on Excel 2007/10 (2-Day)||14:00:00|
No Reviews found for this course.