Request Call Back000-000-0000
Monday - Friday8AM - 9PM
Addressiraq

• to design your organization chart using the excel in alignment with the Microsoft Visio

Course Content
Part 1: Introduction to Human Resources and why it is important?
0/2
Human Resources main functions.
Organization Structures.
Module 1: Recruitment and Selection
Effective Recruitment:
0/9
What is Recruitment
The recruitment Analyst
Online and offline recruitment sources
Overview on Job description and job analysis
Workforce Planning and Forecasting
What is Recruitment Strategy and Workforce Planning Effective
Recruiting Forecasting Personnel Needs (Labor Demand).
Recruiting Process Forecasting the Supply of Inside Candidates.
Job identifying Process Why effective Recruiting is Important.
Effective Selection
0/10
Validity & Reliability.
Essential skills and attributes for Filtering.
Using your selection tools for screening applicant.
Pre-employment testing.
Structuring and preparing for interviews.
Background investigation.
Types of questions that build rapport and uncover experience.
Types of interviews and how to conduct effective interviews?
Selling the organization and the job.
Job Offering.
Module 2: Compensations, Benefits & Payroll
0/9
• What are employee’s compensation and benefits?
• Job Evaluation
• Salary Structure
• Organization Strategic Focus toward the compensation and benefits
• Incentives
• Payroll process & challenges
• Payroll policies and procedures
• Market survey and pay system
• Fixed and variable payments
Module 3: Performance Management
0/5
• What is Performance Management?
• How Does Performance Management Work?
• Tools and Techniques.
• Overview on KPIs.
• Performance appraisal review- The Areas of Strength effectiveness.
Module 4: Employee relations:
0/5
• What Is Employee Relations?
• employee Relations Guidelines
• Methods to maintain effective employee/employer relationships.
• Employee Conduct and Grievances
• Employee Relations Programs For Building And Maintaining Positive Employee Relations.
Module 5: Training and Development
0/8
• Introduction to Training and Development
• What is TNA and why it is important?
• Designing training programs.
• Training Methods.
• Measuring the effectiveness of training programs
• Difference between Training and Development
• Employee Development Plans
• Orienting and Onboarding New Employee
Module 6: Key Concepts for Strategic Management and Organizational behavior:
0/3
• Goal Setting
• Overview on Strategy Formation, implementation & monitoring
• Organizational behavior and its goals
Module 7: Personnel Administration and labor law
0/12
Personnel Administration
• Prepare employees’ files
• Create employees data base
• Managing employee medical insurance
• Personnel policies and procedures
• Employee handbook
Labor and Insurance laws:
• Employee’s social insurance calculations.
• Income tax calculations.
• Employee’s social insurance forms.
• Labor law regulations.
• Labor and social insurance office regulations.
Part 2: Excel for HR Content: Basics of excel:
0/29
• Exploring Excel
• Basic Workbook Skills
• Formatting Data and Cells
• Creating Simple Formulas
• Managing Worksheets
Recruitment:
• create and manage your candidates’ data pool, design your own excel test for your candidates,
• calculate your recruitment activities cost per hire, prepare your hiring decision based on calculating the best candidates result
Performance management:
• create and manage your own performance managed system,
• how to make assessments form according to each job title, mange your training database and extracting the needed reports from it
Advanced excel:
• Analyzing Data with Pivot Tables
• Charting and Drawing
• Named Ranges
• Using Large Spreadsheets
• Working with Columns and Rows
• Working with Data Series
• Working with Outlines
• Working with MS Visio
• Working with Slice
Payroll:
• calculate all the add-ons and deductions for your payroll,
• calculate the income tax, social insurance, design and manage your employees database, extracting all the needed report from it
• How to calculate the differences between your employees salaries and mange this differences to reach to the appropriate internal equity,
• How to apply the appropriate salary increases between the employees with the same title
• How calculate the differences between your company salary scale and your company competitors
Organizational charts:
• to design your organization chart using the excel in alignment with the Microsoft Visio
HRC| Human Resources Certificate
About Lesson


Previous
Next