Using and Excel worksheet, a person can create a monthly budget by creating a layout with the months listed in individual cells along one row of the spreadsheet leaving the first column blank. He can then add headings for income, salary, benefits, pension and total on the blank column.
You can give expenditures individual cells in the same column as income types. These include rent or mortgage payments, utility bills, grocery costs and leisure costs. Once all these headings are on the spreadsheet, you can add formulas for calculations to the cells under each month, so Excel can automatically calculate the numbers as you enter them. For example, when you select the cell next to the heading "total," you can then click on the "Autosum" button on the toolbar, then click and drag to select all the cells that you want to add. You can copy and paste this formula to the corresponding cells for each month.
Calculating the difference between the totals for both expenditures and income types requires another formula. First, designate and select a cell for this total, and use Autosum to create the formula. Select the total cell and type the minus sign into it. Next, hold down the Control key while selecting the second total cell. Pressing Enter completes the calculation. Add figures to each section to create a monthly budget.