How to make salary sheet || Payroll or Payslip in excel 2016 || Creating a Payslip in Just 5 minutes скачать в хорошем качестве

How to make salary sheet || Payroll or Payslip in excel 2016 || Creating a Payslip in Just 5 minutes

In this Tutorial you will learn how to make salary slip or salary sheet in excel 2016, also you will be able how to make payroll system in excel for employees. thanks for watching, subscribe my channel for more videos...    / yadonlinetrainingacademy   ===================================================================== IF YOU ARE NEW TO THIS CHANNEL, Please 😊 Like ❤️ Subscribe & turn 🔔 notifications on! Thank you for watching! ===================================================================== Website https://yadonline.blogspot.com/ Facebook   / kpcomuterskills   ===================================================================== Complete Ms-Excel Course Tutorials    • Five Common Excel Errors and how to fix th...   ======================================================================== Download Excel File from the link given bellow https://drive.google.com/open?id=1agw... ======================================================================== Pay Head in Payroll are given bellow DA The Dearness Allowance (DA) is a cost of living adjustment allowance paid to Government employees, Public sector employees (PSU)and pensioners. Dearness Allowance is calculated as a percentage of basic salary to mitigate the impact of inflation on people. EPF/PF The Employee Provident Fund, or provident fund as it is normally referred to, is a retirement benefit scheme that is available to salaried employees. Under this scheme, a stipulated amount (currently 12%) is deducted from the employee's salary and contributed towards the fund. ===================================================================== Use the following formulas in Payslip or Payroll DA formula = basic salary * 10/100 House Rent = Basic Salary * 8/100 PF = Basic Salary * 12/100 Gross Salary =Basic salary + DA + House Rent + PF EPF = PF / 2 LIC = EPF/2 Deduction = EPF + LIC Net salary = Gross Salary - Deduction ===================================================================== Resume Templates Microsoft word    • Professional Resume Writing and Designing ...   ===================================================================== How to create Question paper in Microsoft word    • How to create question paper in ms word 2016   ==================================================================== Advance Excel formulas and Functions    • Five Common Excel Errors and how to fix th...   ==================================================================== Complete Course of Accounting through tally erp 9    • How to Install Tally erp 9 software on win...   ====================================================================== #payslip, #payrollexcel, #salaryslipexcel,#salaryslipinexcel, #salaryslipbanansikhe