557 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
On a new workbook type in the text and numbers in the same cells as shown below:
You will need to change the column widths.
In cell D2 create a formula using the following information:
Tot Staff Costs = No. Staff * Hrs Worked * 8.75
Copy the formula down the column to work out the other Total Staff Costs.
In cell F2 create a formula using the following information:
Govt. Allowance = 1000 * No. staff
Copy the formula down the column to work out the other Govt. Allowance figures.
In cell G2 create a formula using the following information:
Credit/Debit = Govt. Allowance - Tot Staff Costs - Office Rent
You will need to think if you need to include any brackets in this formula (BODMAS!).
In cell B8, create a formula that will add together all the number of staff.
There is a special button on the toolbar for totals.
Copy the total formula across the row to calculate the other totals.
Save the file with the name MP Office Costs.
You can find other training resources for the subject of this exercise here:
25 Aytoun Street