In Excel for HR Professionals training course, you will learn formatting techniques to convert data from different sources, and how to make the best use of most important formulas for HR. You will learn to manipulate charts and diagrams, use logical functions and link the spreadsheet to other worksheets and applications. Also learn to automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
By attending Excel for HR Professionals workshop, delegates will learn to:
- Calculate the tax deductible amount based on the different salary range
- Display first name, last name with prefix in one single column from three different columns
- Find years of service of employees
- Find the total salary expenses in different regions, different departments
- Total number of employees in the company in different departments
- Find the total salary given to employees of a particular department or designation in a particular month
- Find number of employees joined on particular date/month in any department in any country
- Calculate the bonus based on overall performance of an employee
- Find the number of leaves taken by any employee, find the designation of an employee from his salary
- Count number of directors or any designation in a company
- Display the records according to department, by hire date, by salary etc.
- Calculate the total overtime hours for employees for any month, View summarized salary for all the different countries in different departments
- Set the status, department of an employee through data validation
- Validate the hire date upon data entry
- Calculate salary based on overtime hours
- Calculate the net pay of an employee from his/her daily pay and leaves taken
- Consolidate overtime hours and rate for two employees
- Compare employee’s involvement in department from the working hours using charts
- Find total number of employees working in specific department from specific dates
This Excel for HR Professionals class is suitable for:
- Admin Professionals
- Compensation and Benefits Professionals
- HR Reward and Payroll Professionals
- HR Managers
- Anyone who perform HR functions in their organizations on daily basis