Budget
Level of difficulty: Intermediate
Create your own budget - one which you will find useful. Alternatively, follow this example. To do so you would typically work through the following steps:
| Tip sheets | Glossary | Home | Contents |
Budget |
Level of difficulty: Intermediate |
|
| As an educator you are required to draw up a budget for your department's annual expenditure. You will submit this to the governing body. After your budget has been approved you may need to adjust figures. You will then be required to keep a quarterly record of your expenditure. You will use Microsoft Excel to create this budget. | |
|
|
|
|
Create your own budget - one which you will find useful. Alternatively, follow this example. To do so you would typically work through the following steps: |
||
Description |
Resources |
|
| 1 | Start Microsoft Excel | How to start Microsoft Excel |
| 2 | Type the name of the school and the name of the department. | |
| 3 | Save the file: Save your work regularly. | How to save a file |
| 4 | Modify the heading: Select the heading, change the font, change the font size and colour to make the heading attractive. | |
| 5 | Enter the budget information: Type the budget categories of your choice in Column A , and type the columns headings (consult the example budget for ideas). | |
| 6 | Adjust column widths: Change the columns widths so that the text fits the column. | How to adjust columns |
| 7 | Draw lines: Draw lines of your choice to seperate columns and sections of the budget. | How to create borders |
| 8 | Calculate values (multiply): Use formulae for multiplication to calculate the total costs in the "Budget" column. |
|
| 9 | Copy Formulae: Instead of repeatedly typing a similar formula, you can copy and paste one formula to many cells. Excel changes the row and column references automatically. | How to copy formulae |
| 10 | Add the total costs: You will need to add the costs at the bottom of the "Budget" column as well as the total spent in all four quarters in the "Total spent" column. | How to add a range of values |
| 11 | Calculate values (subtraction): Calculate the "Total left" column by subtracting the value in the "Total spent" column from the value in the "Budget" column. | How to subtract values |
| 12 | Change the number format: Change the format of the value to indicate currency (R) where appropriate. | How to change the number format |
| 13 | Save the file: Save the budget. | How to save a file |
| 14 | Print the file: Print the budget. | How to print a file |
|
|||
|
Related scenarios Creating a chart in Microsoft*Excel. Importing a chart into a Microsoft* Word. Create a marksheet |
 |
 |
|
