How to Create Salary Sheet in MS Excel

‍

‍

Here's how to do it:

‍

1. Open Excel and key in the necessary information and details about the employee.
2. Fill in the details appropriately.
3. Input the earnings and deduction of the employee.
4. To calculate for the net pay as in our example type in "=b17-d17," then press enter.
5. This will be the net pay for the employee on file.