You no longer have to worry about how to put in payee in excel. Our powerful solution guarantees easy and fast document management, allowing you to work on excel documents in a few moments instead of hours or days. Our platform contains all the tools you need: merging, adding fillable fields, approving documents legally, inserting shapes, and much more. You don't need to install additional software or bother with high-priced programs requiring a powerful computer. With only two clicks in your browser, you can access everything you need.
Start now and handle all different types of forms like a pro!
Hello Viewers today we will learn how to make salary sheet or Payroll or Payslip in excel Let start now. First you need to create payhead for salary sheet As you can see above You must know about the payhead of salary sheet or Payroll Start entering data for Salary sheet type s.no, empname designation and basic salary for employee Calculate DA for basic salary which is 10% of basic salary Drag it down to copy it bellow Now calculate HRA which is 8% of basic salary Drag it down to copy it bellow Calculate PF which is 14% of basic salary Drag it down to copy it bellow Now findout the Gross Salary By adding DA+HRA+PF this will be equal to gross salary second method to add the DA HRA and PF Now find EPF which is half of PF Now find LIC which is half of EPF EPF and LIC are the deduction of Employee which is to be subtracted from gross salary So Net salary will be equal to Gross salary -deduction So viewer you learn how to make a salary sheet in excel If you like my videos kindly SUBSC