How to make salary sheet || Payroll or Payslip in excel 2016

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
yadonline.blogspot.com/
Facebook
web.facebook.com/kpcomuterskills
=====================================================================
Complete Ms-Excel Course Tutorials
youtube.com/watch?v=qiJcmVasbKk&list=PL2CnL…
========================================================================
Download Excel File from the link given bellow
drive.google.com/open?id=1agw7_nNqU0-vfaKLM2ZzI…
========================================================================
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
youtube.com/watch?v=eVJw-jR49uI&list=PL2CnL…
=====================================================================
How to create Question paper in Microsoft word
youtube.com/watch?v=Tb2CLuK2LwY&list=PL2CnL…
====================================================================
Advance Excel formulas and Functions
youtube.com/watch?v=qiJcmVasbKk&list=PL2CnL…
====================================================================
Complete Course of Accounting through tally erp 9
youtube.com/watch?v=CT1vUNsICpI&list=PL2CnL…
======================================================================

#payslip, #payrollexcel, #salaryslipexcel,#salaryslipinexcel, #salaryslipbanansikhe