Book Includes Formulas And Functions, Projects In Excel, Pivot Table And Macros. XLS files can also be opened on Android or iOS. Excel Expert (Gujarati) (Gujarati Edition) eBook : Mr.
While applications like OpenOffice allow XLS files to be opened, some features may be limited. Users can open XLS files with either Office for Windows or Office for Mac, and both these programs support features, including macros that have been written in Visual Basic. XLS files are widely used in education and in work, although in 2007 they were replaced by the XLSX file format as the primary file type used for Excel spreadsheets. This file format also allows users to create and record macros using a macro-programming language called Visual Basic. XLS files also support charts, images, pivot tables and more, and this means that they are often the format of choice for anyone doing any form of calculation or working with numerical data. XLS files contain one or more worksheets that are made up of cells that are arranged by row and by column, and they allow users to do calculations by inserting formulas into cells. If you don’t, when you copy the formula to all the other staff members, each formula will refer to Fred Smith’s salary. Useful Salary Slip Formulas 1īasic wage + HRA + Conveyance + Medical + Special allowancesĠ.75% of employee gross wage.The XLS format, also known as the Excel Binary File Format, is the format for spreadsheet files created by Microsoft or other spreadsheet programs.
Step 7: Now take out the printout of the salary slip and sign it and distribute to employees. Step 6: Now subtract all the deductions from the earned gross salary of the employee in that particular month, the balance amount will be the net salary of the employee. Other(Special) Allowances (Balance allowances) HRA (40% of the basic wage for nonmetro cities)Ĭonveyance Allowances ( 1600 Rs in urban areas) Step 5: In another column add deductions such as EPF, professional tax, ESI/health insurance, TDS, and salary advances, etc… Salary calculation formula for the total paid days = (Original gross salary/Total days in the month) X Paid days in that month. The sum of all the earnings will be called the actual gross salary of the employee.
Step 4: Now in one column add all the earnings of the employees such as basic wage, house rent allowances, conveyance allowances, medical allowances & special allowances. To calculate total paid days subtract LOPs from total days in the month. Step 3: Now enter the number of days in the month, and LOPs (Loss of Paydays) of the employee. Step 2: Now enter employee general details like name, designation, department, date of joining, gross salary, bank details, and any other required information as per your choice. Step 1: To create a salary slip/pay slip open a new Excel sheet and write your company name, address, and payslip month & year in the first three rows of the Excel file. Download Excel How to Create a Salary Slip in Excel
0 kommentar(er)
