Click on the start menu; then all Programs; then Microsoft Excel.
Spreadsheet programs are made up of rectangles called cells which are referenced like a map.
Name your file household accounts and click save.
Click on a cell A3 and create an income list, using a cell for each item.
Underneath your income list make a list of all of the outgoings.
Type in the month in column B, then type in the cash amount against each item.
To total up your income, click on the relevant cell (B9) and click auto sum.
The formula bar tells you what cells are to be added together (ie cells B4 to B8).
These cells are highlighted. If correct, hit the enter key. The total appears.
Use auto sum to calculate the outgoings in the total cell B24.
A monthly budget is calculated by subtracting the total outgoings from the total income ie B9 – B24.
First select the ‘balance’ cell (B26), then type the ‘=’ sign in the formula bar;…
click on the ‘total income’ cell (B9); type in '-' sign; click on the ‘total outgoings’ cell (B24)
Hit the enter key, and the monthly balance is calculated for you.
Click here to download this information in a fact sheet. Large page:1MB
Find out more about budgeting with our handy weblinks
