Payroll
Human Resource, Payroll, CTC Preparation in Excel (All legal rights are reserved, no one can claim legal rights)
Ratings 0.00 / 5.00
What You Will Learn!
- Training on Indian Payroll Calculation & CTC Preparation in Excel
- Its almost 30 Mints
- No Risk (we are providing excel practical sheet also, you can download in the last section)
- In CTC Structure just enter the CTC amount then all components will be changed based on the formula
- In Payroll Calculation if you change the no of working days then Gross and Net will be automatically changed because of formula
Description
How to fix the formulas to prepare the CTC structure
Then if you enter the Employee Per Month Salary then all components automatically Changed
For Payroll also we will fix the formula then if you change the employee working / Present Days (As Per Attendance) net amount automatically Changed
Every Month you can observe below points only for payroll :
1. Month Days
2. Employees working Days
3, Any New joiners
4. Any Left Employees
Note : For new employees you just enter employment details and Calculation part you can copy the old employee formula and paste it for new employee.
Income Tax Calculations also explained
Company levels / hierarchy Preparation
Note: Who can learn this Course
HR Fresher’s and Experience people also can learn .
Note : For new employees you just enter employment details and Calculation part you can copy the old employee formula and paste it for new employee.
Income Tax Calculations also explained
Company levels / hierarchy Preparation
Note: Who can learn this Course?
HR Fresher’s and Experience people also can learn .
Note : For new employees you just enter employment details and Calculation part you can copy the old employee formula and paste it for new employee.
Income Tax Calculations also explained
Company levels / hierarchy Preparation
Note: Who can learn this Course?
HR Fresher’s and Experience people also can learn.
Who Should Attend!
- HR People Can Learn This Course (Freshers or Experience)