Spreadsheet user guide

Authors Avatar
. Go to the start menu, all programs then select Microsoft excel and click it using the left mouse key.

2. Collect relevant data e.g. gross salary, name, job etc.

3. The columns should be entitled: Surname, Forename, Occupation, Hours, Hourly rate, Date issued etc.
Join now!


4. Enter the information in the correct column.

5. Enter the formulas for GROSS weekly income (hours worked*hourly rate), Weekly tax rate (gross weekly pay*0.2), Weekly national insurance (gross weekly pay*0.05), Total Deductions (weekly tax + weekly national insurance) and weekly NET pay (gross weekly pay-total weekly deductions).

6. High-light row 1 (the row which contains the titles) click format cells, select the tab which says alignment and on the right hand there is a semi-circle with a line with a red node (diamond shaped object) at the end. With this, you can alter the angle ...

This is a preview of the whole essay