Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to make salary sheet || Payroll or Payslip in excel 2016. That video is uploaded by YadOnline training academy at 2018-06-10T11:24:10-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [3PeCwuKX5es]
| Name | How to make salary sheet || Payroll or Payslip in excel 2016 |
| Video Uploader | Video From YadOnline training academy |
| Upload Date | This Video Uploaded At 10-06-2018 18:24:10 |
| Video Discription | 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... www.youtube.com/yadonlinetrainingacademy ===================================================================== IF YOU ARE NEW TO THIS CHANNEL, Please 😊 Like ❤️ Subscribe & turn 🔔 notifications on! Thank you for watching! ===================================================================== Website https://yadonline.blogspot.com/ https://web.facebook.com/kpcomuterskills ===================================================================== Complete Ms-Excel Course Tutorials https://www.youtube.com/watch?v=qiJcmVasbKk&list=PL2CnLPvKeAZU8tNMx3O5v3zP-dweHe3M8 ======================================================================== Download Excel File from the link given bellow https://drive.google.com/open?id=1agw7_nNqU0-vfaKLM2ZzI1Qgkh7EhLjc ======================================================================== 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 https://www.youtube.com/watch?v=eVJw-jR49uI&list=PL2CnLPvKeAZUBoQ0fZ0oMdN1H9N2JoHyA ===================================================================== How to create Question paper in Microsoft word https://www.youtube.com/watch?v=Tb2CLuK2LwY&list=PL2CnLPvKeAZVDFk5Y-yxvGG0FxD09Bd7v ==================================================================== Advance Excel formulas and Functions https://www.youtube.com/watch?v=qiJcmVasbKk&list=PL2CnLPvKeAZU8tNMx3O5v3zP-dweHe3M8 ==================================================================== Complete Course of Accounting through tally erp 9 https://www.youtube.com/watch?v=CT1vUNsICpI&list=PL2CnLPvKeAZW2XKLkldynnhvGRhN5Ph8q ====================================================================== #payslip, #payrollexcel, #salaryslipexcel,#salaryslipinexcel, #salaryslipbanansikhe 3PeCwuKX5es |
| Category | Education |
| Tags | salary slip | salary sheet | ms excel | microsoft excel | payroll in excel | Payroll sheet excel in hindi | payroll calculation excel sheet | payroll | Salary Sheet | Salary Statement | salary sheet in excel | salary statement in excel | Employees Pay Roll | Employee Payroll | Gorss Salary | learn excel | excel | Calculate Medical Allowance | Learn Excel in Hindi | Excel Hindi Tutorial | Excel formulas | tutorial | basic computer | salary pay slip | pifra | payslip | limited company salary slip |
