Breakthrough Performance For HR in Excel
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 ObjectivesUpon 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.
- 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
Price and Duration
S$600 per pax for this 2 days course.
In a typical Excel course, participants are just taught the A to Z on the formulas and functions, for the purpose of passing the certification tests. After attending these courses, the participants are left on their own to figure out how to apply the formulas and functions effectively in their unique work situations. Some took months and years to accomplish this, but many never ever discovered how. We decided to fill the gap by offering our courses tapping on our Excel experiences, from our Excel-related work experience accumulated over the years (since Lotus 1-2-3 days) and regular consulting work done with companies such as Discovery Asia, Johnson and Johnson, EQ Insurance, DP Architect, etc.
WHY SHOULD YOU CONSIDER OUR COURSES?Unlike the gamut of basic, intermediate and advanced Excel courses geared towards achieving high score for the test given at the end of the training, our solution-based Excel courses work through real-life business situations and problems that business users encounter daily in their jobs and share with them quality solutions aimed to improve their work productivity and efficiency. ...