How to create salary Slip in MS-Excel

How to create salary Slip in MS-Excel

Hello Corey Finnerty, To make a salary sheet in MS- Excel you will need to the follow:

1. First get together all salary information need for the spreadsheet (job titles, employees pay rates, and salaries)

2. Next you will need to start on your Excel sheet and add all job titles in a column (remember to leave a cell empty underneath so there's enough room for pay grades of every employee)

3. You will need to create a column with the salaries to go along with the employee's pay grade. ( Remember everything needs to be in one row starting with job title on to the last which is salary.)

4. Now you will need to create the following titles in columns: for salary if its going to state weekly, bi weekly, monthly, or annual amount.

5. You need to add the formulas in the cells and you will see the sums beginning show in the selected cells.