+91 9999420393
011 40109421
PG Available for Outsider
Open 7 Days a Week

HR Generalist with Free SAP HR HCM & Adv. MS Excel Practical Training Course

4 Star Rating: Very Good4.95 out of 5 based on 950 ratings.

Free SAP HR HCM & Adv. MS Excel
Statutory Compliance
Compensation and Benefits
IR/ Labour Law Compliance
Performance Management System
Training & Development
Recruitment & Manpower Planning

Read More


ISO Certified HR Course with 100% Placement Assistance.
80% Practical and 20% Theoretical Session.
Portal, Salary (Cloud-Based) Software with Live Access & Excel.
Free Workshop Conducted by Industry Experts.
PD Class + Interview Preparation & Resume Building.
HR Course Recommended by All HR Heads.
Real Learning on Live Projects of Clients.
Get Trained from Industry Experts.
Live Assignments & Case Studies & Role Play.
Job portals, Payroll processing software and online challans.

HR Generalist with Free SAP HR HCM & Advanced MS Excel Practical Training is a valuable course for people who are interested in learning the practical aspects of human resource management in a short amount of time. This HR Practical Training in Delhi is meant to help people who have yet to enter the corporate world and it is also for those who want to move their career forward in the corporate but have been unable to do so till now. We have the top-notch trainers who will help you to get well-versed with all aspects of HR by explaining concepts in a simple & understandable manner. You will always benefit a lot from this course, we are sure of that!!


Valid Certification

When the course is completed you will get a HR Certification that will help you enter or progress in the corporate world.

Seasoned Faculty Members

Our trainers are HR industry professionals who have deep expertise in imparting training and working in the corporate world.

100% Placement Assistance

We ensure that you get many opportunities to give interviews to ensure that you get a good job. Our placement team is highly efficient.

Lab Facility

You get the opportunity to work in a real lab where a few technical Assignment would help you learn better.

Awesome Workshops

Real time projects help you learn new concepts better and top class case studies let you learn from real-life examples.

Administrative Support

A skilled admin team helps you to plan your schedule better and get rid of all the doubts. They also offer support during admission and placement processes.

In the current economic scenario, the task of managing people is a gigantic one. Companies want the employees to give maximum output and they don’t want to pay much too. This is where a person with HR Generalist Training steps in. When you complete our HR Generalist with Free SAP HR HCM & Adv. MS Excel Practical Training Program, you will be a valuable resource who helps companies to retain the best people.

We will make sure that you learn about every aspect of human resource management, be it legalities related to HR Payroll Processingcompensation management, staffing, performance management, training & development or industrial relations. Our efforts will be to ensure that you become an expert in your field and beat all others during an interview for HR generalist by answering all the questions flawlessly.

A team of experts has brainstormed the content of this course after understanding what the corporates expect from individuals wishing to be HR Generalists. We also make valuable additions to this course to enable you to learn all the dynamics related to human resource management.

To know more about this wonderful course, connect with any of our team members and they will guide you on why this practical learning training method will work for you.

  • HR Jobs are lucrative, stress-free and pay well
  • Each organization needs an HR department so you will rarely be unemployed
  • It’s a great way to start the career, especially for freshers
  • You will be considered an asset
  • Your career path would be clear and easily achievable

Who Should Learn?

  • Fresh graduates looking for a fulfilling job
  • Mothers who wish to rejoin the corporate world post a sabbatical
  • HR professionals seeking career growth
  • Professionals working in just one area of human resource management like recruitment who want a more enriching job
  • Final year students looking for a good job but not getting placed via their college

HR Generalist with Free SAP HR HCM & Adv. MS Excel Practical Training Course is becoming a hot favorite of students and professionals. Why? Because it guarantees job placement and offers certification practical training at affordable costs!!

Key Highlights

  • Only seasoned trainers who have good rich experience in the corporate world will train you
  • You can easily access all hardware and software tools that are needed to learn the practical HR
  • At the end of the course, you will get a valid hr certification that will kick-start or enhance your career
  • We will provide you with a lot of job opportunities via our placement sessions when you are on the last leg of this practical training
  • As a student, you can ask as many questions you like from the trainer (No doubts or confusion again!!)
  • The duration of this course may seem lengthy to some but it’s worth the time you invest. The returns can be reaped for many years.

Course Duration:  100 - 120 Hours with 4 - 5 Trainers for 1 to 11 Modules, Talent Magnifier Introduce Advanced HR Generalist with Free SAP HR HCM & Adv. MS Excel Practical Training Delivery Method:

  • Web and desktop Based Classes
  • Projector or LED-Based Classroom
  • Classroom & Online sessions led by an instructor
  • 80% Practical and 20% Theoretical Session.
  • Presentations and demonstrations by Industry Experts.
  • Practical explanations of concepts
  • Portal, Salary (Cloud-Based) Software with Live Access & Excel.
  • Recorded Session will be provided by Faculty for Online Candidates.
  • Real-time opportunity to work on client projects
  • Regular assignments to test your skills.
  • Handouts and Notes will be provided by Faculty. (Notes will be module bases)
  • Free Workshop Exposure with Interview Preparation
  • Completion of HR Certification will be provided by Talent Magnifier
  • Talent Magnifier Provide 100% Placement Assistance and Support.

Please note that the classes are available on a module basis as well as your comfort zone.

Course Details

HR Generalist with Free SAP HR HCM & Advanced MS Excel Practical Training Course Modules

Employees’ Provident Fund (EPF)
  • Provident Fund Calculation
  • Pension Fund Calculation
  • Employees’ Deposit Linked Fund
  • Interest
  • Penalty

Workshop Session

  • Shram Suvidha Portal
  • Universal Account Number
  • Electronic Challan cum Return
  • AADHAAR Updation
  • PAN Updation
  • Bank details updation
  • Eligibility Register
  • Member Claim Forms
Payment of Bonus
  • Bonus Calculation
  • Available Surplus
  • Allocable Surplus
  • Set-on & Set-off
  • Grievance by employee
  • Penalty

Workshop Session

  • Bonus Calculation Sheet
  • Bonus Payment Registers & Records
  • Annual Return
  • Display
Employees’ State Insurance (ESI)
  • ESI Calculation
  • Interest & Penalty
  • Medical Benefit
  • Maternity Benefit
  • Funeral Expenses
  • Monthly Pension

Workshop Session

  • Shram Suvidha Portal
  • Sub-Code Registration
  • E-Pehchan Card
  • Aadhaar Updation
  • Monthly Challan
  • Accident Register and Records
  • Declaration Form
  • Claim Forms
Payment of Gratuity
  • Gratuity Calculation
  • Maximum Gratuity amount
  • Tax on Gratuity
  • Group Gratuity Policy

Workshop Session

  • Nomination Forms
  • Gratuity Claim Form
  • Display
Maternity Benefit Act, 1961 (New topic added)
  • Objective,
  • Applicability;
  • Eligibility conditions;
  • Benefits and facilities for women employees;
  • The responsibility of the Employer;
  • The penalty for contravention of the Act

Workshop Session

  • Registers and Records
  • Annual Return;
  • A grievance by women employee;
Payment of Wages Act, 1936 (New topic added)
  • Objective,
  • Applicability;
  • Eligibility conditions;
  • The responsibility of the Employer;
  • The penalty for contravention of the Act

Workshop Session

  • Registers and Records
  • Annual Return;
  • A grievance by an employee;
Minimum Wage Act, 1948(New topic added)
  • Objectives
  • Applicability
  • Notification
  • Provisions
  • The penalty for contravention of the Act

Workshop Session

  • Register to be maintained
  • Display (Notice)
  • Annual Return;
  • A grievance by an employee;
Payroll Management (On Excel and Cloud-based Software with live access)
  • Components of Salary;
  • Basic, HRA, DA, Conveyance, LTA, etc.
  • Designing CTC, Gross Salary, Net Salary
  • Overtime and Leave Encashment
  • Labour Welfare Fund (LWF)
  • Professional Tax (PT)
Income Tax & Investments
  • Income Tax calculation
  • Rebate on Income Tax
  • Calculation Surcharge
  • Calculation of Education Cess, Health Cess
  • Taxability of Allowances
  • Tax Deduction on Investments
  • Tax Deducted on Source (TDS) Certificate
  • Investment Declaration Form

Workshop Session (On Excel and Cloud-based Software with Live Access)

  • Attendance Sheet
  • Leave Register
  • Overtime Sheet
  • Overtime Amount Sheet
  • Salary Sheet
  • Pay Slips,
  • Full and Final Settlement
  • EPF Report
  • ESI Report
  • LWF Report
  • Professional Tax Report
  • Live Cloud-based Payroll Software
  • Investment Declaration Form
  • TDS Certificate ( Form 16)
  • Online ITR Filing
HR Practical Session With Advanced MS Excel - Topics Covered
  • CTC Worksheet
  • Attendance Sheet:
  • Leave Register:
  • Overtime Calculation:
  • Salary Sheet:
  • Pay Slip:
  • ESI &EPF Report:
  • LWF & PT Report:
  • Bonus & Gratuity Calculation:
  • Income Tax Calculation:
  • Full & Final Settlement:
  • Annual Returns:
  • Contract Renewal Schedule:
  • Basics:- Reference, Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split, Goal Seek
  • Mathematical Functions:- Sum, max, min, Sumif, Sumifs, Count, counta, Countifs, Countblank, Average, Averagea, Subtotal, Round Roundup, Rounddown,
  • Lookup Functions:- Vlookup, Hlookup, Pivot Table, Index, Match, Indirect
  • Date & Time Function:- Day, Month, Year, Edate, Eomonth, Network days, Hour, Minute, Second, Now, Today, Time
  • Conditional functions:- if, and, or, iferror
  • Text Functions: – Concatenate, Find, Search, Substitute, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Large, Small
  • Charts:- How to Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, and Column Chart.
Contract Labour ( Regulation And Abolition) Act, 1970
  • Objectives
  • Applicability

Workshop Session

  • Registration Process
  • License Process
  • Returns
  • Facilities
  • Registers and Records
  • Display
Factory Act, 1948
  • Manufacturing Process
  • Objective
  • Scope
  • Factory Definition

Workshop Session

  • Registration and Licensing Procedure
  • Administrative Setup
  • Health-related Provision
  • Safety-related Provision
  • Welfare Relative Provision
  • Working Hour of Adult Person
  • Annual Leave with wage
  • Employment of young person
  • Annual & half Yearly Return
  • Registers and Records
Disciplinary Action/Termination/Misconduct
  • What is Misconduct
  • How to Draft Chargesheet/ Show cause Notice
  • How to serve the Charge sheet
  • Conduct the Domestic Inquiry
  • What is suspense Allowance
  • How to conduct Domestic Inquiry with Practical
  • Termination
BOWC (Building & Other Constructions Workers) Act, 1996
  • Objective;
  • Applicability;
  • Eligibility conditions;
  • The responsibility of the Employer;

Workshop Session

  • Registration Procedure
  • Registers, Records, and Returns;
  • A grievance by an employee;
  • The penalty for contravention of the Act
Trade Union Act, 1926
  • Definition
  • Condition/ clause
  • Function
  • benefits and Drawback
  • Role Play
Apprentices Act, 1961
  • Objectives
  • Contract of Apprentices
  • Termination of Apprentices Contract
  • The obligation of Employers toward an Apprentices
  • Obligation of Apprentices
  • Payment to Apprentices
  • Health, Safety, and Welfare of Apprentices
  • Rules and Guideline
Delhi Shops & Establishments Act, 1954
  • Objectives
  • Applicability
  • Conditions of work

Workshop Session

  • Registration
  • Registers to be Maintained
  • Display (Notice)
Industrial Disputes Act, 1947
  • Objective
  • Scope

Keyword used

  • Closer
  • Conciliation Officer
  • Industry Disputes
  • Workmen
  • Lockout
Retrenchment / Lay Off
  • Retrenchment of workmen
  • compensation and Condition
  • Prior permission by the govt. for retrenchment, Lay off
  • Compensation Prior permission for lay off
  • Authorities under this Act, for Investigation and settlement of Industrial Disputes
SHWW Act, 2013
  • What is Sexual Harassment
  • What is the workplace
  • Aggrieved women
  • Preventive Authorities
  • Employer
  • District officer (DO)
  • The responsibility of the employer and Do Complaints Committees

Workshop Session

  • Internal Complaints Committee (ICC)
  • Local Complaints Committee (LCC)
  • Redress of Sexual Harassment
Part 3.1 – Fully Practical Legal Calculations Class
  • Calculation of Full and final settlement
  • Calculations of a Notice period
  • Calculations of LTA
  • Calculations of Medical Reimbursement
  • Calculations of Man days for required of all returns like factory and contractor returns etc.
  • Calculations of Attrition and issue &Control
  • Calculations of absenteeism
  • Calculations of suspension allowance
  • Calculation of Overtime with new rule
  • How to Draft the charge sheet in English for staff
  • How to Draft the Charge Sheet In Hindi for worker
Part 3.2 – How to Get Registration with legal Authority
  • Factory Registration/Licensing with full Procedure
  • Contractor Registration/Licensing with Full Procedure
  • Air & water NOC & Consent with Full Procedure
  • Standing Orders Certification with Full Procedure
  • Fire NOC with Full Procedure
Part 3.3 – HR Audit
  • What is HR Audit
  • Legal Compliance Audit
  • HR Payroll Audit
  • HR Policy Audit
  • How to make the HR Audit Report?
  • Define Performance Management System
  • Aligned with Organization Goal
  • Band Structure formation in reference to PMS
  • Distribution/ Mapping the KRA and KPI
  • Competency Design as per Band and level
  • Design a PMS level wise
  • Reviews & Counseling by PIP (Performance Improvement Plan)
  • Personal Development Plan and Review
  • Presentation of Performance Management System
  • Hierarchy Chart Design
  • Draft and Design of Performance Appraisal Form
Workshop Session
  • Role Play Model
  • Case Study
  • Collective Feedback Consolidation
  • Negotiation at the time of increment or Hike
  • Promotion and Appreciation Discussion
  • Core issues – Grievance Handling Procedure and Segmentation
  • Career Development & Opportunities
  • Stress Management & Recreational Facilities
  • Involvement and Engagement
  • Reward & Recognition
  • Joining formalities
  • Exit Interview and Retention Process
  • Work-Life Balance and Employee Benefit Program
  • Meeting Etiquette in Corporates

Workshop Session

  • Communication Downward, Upward, Horizontal
  • Gamification and Modern age engagement activity
  • BE open to coach and mentor
  • BE Open to new Idea and Initiative
  • Human Resource Round Table
  • Practical Role Play for Employee Relationship Building
  • Attrition Management
  • Identify Policy Need
  • Policy framework
  • How to draft Policy? Design and standard format of the policy
  • Policy Communication to Employees
  • Total 10 Policy Sample class, for example, Leave Policy, Meal & Conveyance Policy, IT Policy etc.
  • Training Need Identification
  • Training Budgeting
  • Preparation of Training Calendar
  • Training Feedback Analysis
  • Competency Mapping
Workshop Session
  • Training Module Design
  • Case Study on Planning Training Program
  • Need and Gap Analysis
  • Recruitment & Selection Overview
  • Manpower Planning and Requisition Process
  • Practical Session of Sourcing through different Job Portals, social media.
  • Screening & Short-Listing
  • Retention Management
  • Salary Negotiation
  • Practical Talent Acquisition Candidate Coordination
Module 9.1- Introduction on ERP and SAP HR / HCM
  • Introduction to ERP & SAP
  • Overview on SAP HR Sub Modules
  • Introduction to Project Implementation Methodologies (ASAP Methodology)
  • Implementation Road Map
  • System Land Scape – 3 Tier Architecture
Module 9.2-Introduction to Personnel Administration
  • What is an Info type?
  • Info type Operations- Create, Change, Copy, Delete, Overview using PA30, PA20
  • Fast Entry of Info type
  Important Info type T Codes you Must Know
  • How to view all Info types Saved for an Employee
  • All About Info type 0003 – Payroll Status
  • Time Constraints
  Personnel Action
  • SAP Personnel Actions
  • How to Delete a Personnel Number
Module 9.3 – Organizational Management
  • Structures In SAP
  • Object Types, Validity Dates, Info types
  • Expert Mode
  • SAP PPOCE: How to create an Organizational Unit
  • Positions are Job Roles defined in a Company
  • How to CREATE, COPY & DELIMIT a Position: SAP PPOME
  • identify-a-position-as-head-of-org-unit.html
  • How to assign a Job & Cost Center to a Position
  • How to display Organizational Structure with Positions
Module 9.4 – Time Management
  • Time Evaluation Essentials
  • How To Run Time Evaluation
  • How To CHECK Time Evaluation Results
Module 9.5 – Payroll
  • Overview Of Payroll Process
  • Control Record
  • How to execute Payroll
  • How To Check Payroll Results
  • How to DELETE Payroll Results
Must know Payroll Information
  • What is Off-Cycle Payroll
  • How to Audit Payroll
  • What is MATCHCODE
  • Types of Wage Types in SAP
  • Wage Type Reporter
Post-Payroll-Run Activities
  • Bank Transfer
  • How to Create a Bank Key
  • Posting to General Ledger
  • All About Ad-Hoc Query
Module 9.6- Recruitment
  • Introduction to Recruitment
  • Workforce requirement and Advertisement
    • Media
    • Recruitments instruments
    • Address for recruitments instruments
  • Transferring of applicant data to personnel Administration
  • SAP HR Interview Question
  • Frequently Asked Interview Questions and Their Answers
  • Communication & Body language During Interview
  • Resume Building: How to prepare a resume?
  • Writing a Job Application letter or mail
  • First Impression: How to crack Telephonic Interview?
Free Workshop for 7 Days by MNC Industry Experts.

HR Generalist Course Time & Duration Details

Course ModulesDuration (Hours)Duration (Weekend)
Duration (Weekdays)
(Tuesday - Friday)
Module 1 - 11100 - 120 Hours5 - 6 Months2.5 - 3 Months
Module 1 - 785 - 95 Hours4.5 - 5 Months2 - 2.5 Months
Module 1,2,3,4 & 880 - 90 Hours4 - 4.5 Months2 - 2.5 Months
Module 1,2,4 & 870 - 80 Hours3 - 3.5 Months1.5 - 2 Months
Module 1, 2 & 375 - 85 Hours3 - 4 Months1.5 - 2 Months
Module 1,2 & 865 - 75 Hours2.5 - 3.5 Months1.5 - 2 Months
Module 1 - 260 - 70 Hours2 - 3 Months1.5 - 2 Months
Module 4,5,6,7 & 830 - 35 Hours2 - 3 Months -
Module 4 & 720 - 25 Hours1.5 - 2 Months -
Module 115 - 20 Hours1.5 - 2 Months2 - 3 Weeks
Module 215 - 20 Hours1.5 - 2 Months2 - 3 Weeks
Module 320 - 25 Hours2 - 2.5 Months3 - 4 Weeks



For HR generalist course any graduate can join this course from any field. The BBA and MBA candidates have great scope in this field.
HR Payroll training course is very popular and we offer professional training with certification. It is a short-term course of 25-35 hours. The course offers desktop based training, live demonstrations, presentations, workshop, and placement.
There is a huge demand for this course. Anyone can join this course like fresh graduates, individual, women who want good career start, IR experts, HR professionals, MBA, and graduates.
If you join our institute for HR training you will get an opportunity to get placed in MNC’s as a Human Resource Manager, HR consultant, Training, and Development Manager, HR executive and much more.
Yes, we provide guaranteed placement in HR companies after the completion of certificate courses in HR.
Our HR courses are designed for everyone. Any graduate can join HR certification and training and switch their job.