Excel for HR Professionals
Excel for HR Professionals
Sign up for a one-day, advanced Microsoft Excel course and certification program from Trainingz4u. The class is intended to teach participants how to work with advanced excel functions and formulas to enable them to be better t their jobs as HR professionals and to help them create and manage databases of employees, including managing payroll and generating payslips.
Intended Audience:
People who regularly perform HR and administration tasks, including those working in roles such as HR and administration professionals, compensation and benefits professionals, HR reward and payroll professionals, and HR managers.
Training Objectives:
By the end of this course participants will be able to
Answer these questions using Excel
- Keeping track of employee information such as contact details, job titles, and hire dates
- Calculating and analyzing employee compensation and benefits data
- Managing and tracking employee performance metrics
- Creating and managing employee schedules and time-off requests
- Generating reports on employee turnover, absenteeism, and other HR metrics
- Tracking and analyzing employee training and development data
- Maintaining and updating employee records and files
- Managing and tracking employee attendance and time tracking
- How many employees do we have in total department wise and against budget?
- What is the average tenure of employees in the company?
- How many employees have reached their anniversary date this month?
- What is the average salary of our employees as per job level?
- How many employees have been promoted in the last quarter?
- How many employees have received a salary increase in the last year?
- How many employees have left the company in the last year with category of reasons?
- What is the turnover rate for our company?
- How many open positions do we currently have?
- How many applicants have applied for open positions?
- How many new hires have we made in the last quarter?
- How many employees have received training in the last year?
- What is the cost of employee benefits?
- What is the absenteeism rate for our company?
- How many employees are eligible for retirement?
- How many employees have received a performance review in the last quarter?
- Creating and managing employee budgets.
This is not an exhaustive list and many many more questions may be answered
Additionally participants will be able to do the following
- Reports –
- List reports with custom views
- Consolidate data
- Create Masters-
- Create employee master name address, status, grade, salary etc
- Date and number validations
- Custom validations
- Leave Records & Calculations-
- Using If Function effectively to find leave eligibility
- Calculation of leaves
- Leave balance records
- Using conditional formatting to find the leave dues and accrued
- Compensation & Benefits-
- Calculation of salary & benefits
- Computation of employee bonuses
- Generating thousands of payslips at click of button using excel
- Ensuring correct payment of salaries
- HR data formatting-
- Formatting dates correctly
- Conditional formatting
- Removing duplicates
- Highlighting duplicates
- Using data bars for performance reviews
- Using greater or less than for employee incentives
- Using icon sets for job levels
- Calculation of work days and net work days as per local calendar
- Calculation of week day as per local calendar
- Calculation of years of service
- Creating HR MIS and Charts-
- Creating charts
- Customizing charts
- Automating charts
- Creating custom MIS
- Vendor Management-
- Creating rate master
- Lookup of value of rate master
- Learning Vlookup
- Eliminating Errors
- Automating Tasks-
- Using macros
- Automating monthly reports
Book now and get best price
+ Sure we offer corporate trainings
-Are Purchase Orders acceptable from corporate clients?
+ Yes ofcourse. PO is accepted.
-Is Demo Class Available?
+ Yes. Demo is available on request.