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

HR Payroll with Free Adv. MS Excel Training Course

Compensation and Benefits
HR Payroll Processing
Payroll Software Training
Salary Calculator in Excel
Provident Fund Registration

Statutory Compliance
Labour laws Reports

Read More

HR Payroll Training Course is a practical training program that helps people to learn different aspects of compensation and benefits. It is useful for people who have a head for numbers and learn about payroll software training so that they can get jobs as payroll executives and payroll managers. Every company and HR department needs a payroll expert who can salary calculator in excel, salary slip format Practice,pf, esic, epfo, online efiling,form returns professional tax slab calculation, provident fund registration and see that they are offered in a timely manner. They also need to know about the legal regulations regarding payroll processing and adhere to the same. We ensure that your learning is accurate and you don’t make common mistakes by teaching you right.


Valid Certification

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

Seasoned Faculty Members

Our trainers are 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 assistance team is highly efficient.

Lab Facility

You get the opportunity to work in a real lab where a few technical tests 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 these tough economic conditions, all the employees want their salaries to be dispersed at the earliest and without any mistakes. They also want to get paid for the extra hours they have put in and the extra work they often do on weekends. As management people rarely have the time to take care of salary computation and disbursal, they hire a payroll executive to do the deed. We at Talent Magnifier will train you in all aspects of payroll management so that you can calculate the payroll of fewer than ten employees to thousands of employees in a flawless manner.

We train you to calculate salary as per the legal regulations such as EPF, ESI, etc. In our Live Payroll Software Training Sessions, you will also get to learn about the computation of various aspects of a salary, from HRA to travel allowance and DA to the conveyance. We also make you an expert on online ITR filing so that you can file individual and business taxes flawlessly. You also get pertinent MS Excel Training so that you can use this amazing software to do the calculations instead of depending on manual computation methods that are long, tiring and tedious.

  • You will be an expert in all 3 aspects of payroll management, computation via MS excel, legal compliance and accurate calculation
  • You will have ample job opportunities as each organization needs a payroll expert who is aware of the law as well
  • As a fresher, you can get a job with a good salary
  • If you do your work honestly, you will have a lot of job security as management won’t want to replace you
  • Your career will grow as the company grows because you will easily calculate the salary of more people with the passage of time

Who Should Learn?

  • Fresh graduates who like numbers
  • Women looking to rejoin the corporate world after a few years
  • People from other fields like sales who are tired of job targets
  • People working in an HR field they don’t like much such as recruitment
  • People seeking career enhancement like data entry operator to payroll executive
  • Students who aren’t placed by their colleges
  • Payroll executives who want to update themselves on latest laws and technology

HR Payroll Training Course is a popular course among young and experienced learners because it lets people be an expert on payroll management in just a few weeks and get a job via our amazing placement sessions.

Main Highlights

  • Professional trainers and payroll gurus will teach you
  • We will let you know about all the laws related to payroll management so that your company doesn’t make a mistake accidentally
  • You will get a certification when the course ends and it will add more shine to your resume
  • You will get loads of job opportunities via our placement sessions
  • All the information usually imparted during a year’s course is encapsulated to save your time
  • You can clear your doubts whenever you like without fearing scolding from a trainer. They are all eager to help you

Course Duration:  25 - 35 Hours with 2 - 3 Trainers for 1 to 2 Modules Talent Magnifier Payroll Processing Training Deliver Method:

  • Web-based training
  • Desktop-based training
  • Classroom training
  • Live Demonstrations
  • Interactive Presentations
  • Practical Sessions
  • Presentations/Demonstrations
  • Handouts/Assignment
  • Workshop Exposure
  • Talent Magnifier Provide 100% Placement Assistance

The classes are available on module basis too.

Course Details

HR Payroll with Free Advanced MS Excel Course Module

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.

Course Time & Duration Details

Course ModulesDuration (Hours)Duration
Duration (Weekdays)
(Tue. - Fri.)
Module 1 - 260 - 70 Hours2 - 3 Months1.5 - 2 Months
Module 115 - 20 Hours1.5 - 2 Months2 - 3 Weeks
Module 215 - 20 Hours1.5 - 2 Months2 - 3 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.