How to make salary sheet Payroll or Payslip in excel 2016

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=3PeCwuKX5es

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 f... • ======================================================================== • 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 Desig... • ===================================================================== • How to create Question paper in Microsoft word • • How to create question paper in ms wo... • ==================================================================== • Advance Excel formulas and Functions • • Five Common Excel Errors and how to f... • ==================================================================== • Complete Course of Accounting through tally erp 9 • • How to Install Tally erp 9 software o... • ====================================================================== • #payslip, #payrollexcel, #salaryslipexcel,#salaryslipinexcel, #salaryslipbanansikhe

#############################

New on site