Excel tutorial salary sheet. Select cell c6 in the worksheet. 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 employee. Salary sheet is a ready to use template in excel google sheets openoffice calc and apple numbers that helps you to perform the salary calculations with ease. Learn how to make salary sheet in microsoft excel.
How to make salary sheet in ms excel tutorial in hindilinks facebook. Now you can learn how to make salary sheet in excel within 5 minutes. Salary sheet in excel can be made very easily with this free template. It is a payroll document in which you can record payroll data for multiple employees along with a salary slip prepared according to indian rules of employment which includes provident.
When working as an employee or worker. In this tutorial the name rate will be given to cell c6 to identify the deduction rate applied to employee salaries. Type rate in the name box and press the enter key on the keyboard. Md shariatullah sharif created many videos in ms school on ms excel in bangla tutorial 2019.
The named range will be used in the deduction formula that will be added to cells c6 to c9 of the worksheet. In this video i am showed you how to make a salary sheet and registry book in bangla. Grow your career consutancy httpslptinstitutecourses. You can download salary sheet excel file from this link.