How to Make a Monthly Budget on Excel

1. Click 'Start' > 'All Programs' > 'Microsoft Office' > 'Microsoft Office Excel.'
2. Click cell 'A1,' type 'Expenses,' click cell 'B1' type 'Amount,' click cell 'D1,' type 'Income' and then click cell 'E1' and type 'Amount Earned.'
3. Click cell 'A2,' type the name of a monthly expense (rent, car payment, food etc.) press the 'Enter' key, type the name of another expense and then continue in this manner until all expenses you plan to incur are listed in column A. Repeat this step, clicking on cell D2 and entering sources of income on each line instead of expenses (income from each job, tips, interest, gifts, etc.)
4. Click cell 'B2,' type the amount of money you plan to spend on the expense in cell A2, press the 'Enter' key, and then continue typing in the anticipated amount you will spend on each expense. Repeat this step, clicking on cell E2 and entering amounts corresponding with each source of income. You will now have lists of all of your planned expenses and sources of income.
5. Click cell B2, hold down the mouse button and then drag the mouse down to select the values of all planned expenses.
6. Click the 'Auto sum' button under the 'Editing' group on the ribbon (the main toolbar at the top of the Excel interface.). A total of all planned expenses will appear underneath column B.
7. Repeat steps 5 and 6, selecting cell E2 instead of B2. The total of all planned income sources will appear under column E2.
8. Click on an empty cell underneath the lists press '=' click on the cell containing the total of all income, press '-' and then click on the cell containing the total of all expenses and press 'Enter.' The cell will display the difference between planned income and expenses (the amount of money you will have left over after you pay all your planned expenses.).
9. Hold the 'Control' key, press 'S,' enter a name for the budget in the space provided and then click 'Save.'