How to Manage Your Budget With Microsoft Excel

STEPS:

1. Open Microsoft Excel

2.  Type the title of your table. Ex. "My Monthly Budget".

3. Label the Row and Column Headers according to your daily needs. You may put as much as you want to have a more exact result. 

4. At the savings column, select one cell and enter the formula:
a. Type "=" in the first cell under the savings header.
b. Click the cell with the same row as the cell in the savings column header from the allowance column.
c.Type "-" for subtraction.
d.Type "SUM(.
e. Highlight the cells under each expenditure for the row you are currently computing then ")" to finish the formula
f. Press Enter.
g. Try to enter values in the cells on that row to see if the formula you made is correct.
h. After checking, select the cell where you placed the formula and drag down the "+", at the lower right corner of the cell, until the last row of Savings column.

5. If you want to get the total for each column, simply enter the formula:
a. At the first cell after the "Total" row header(If you haven't placed it yet, you may place it under the last day of the week), type "=SUM(" then highlight the cells to be added in the column, then type ")" and press enter
b. Select the cell where you placed the formula and drag the "+", at the lower right corner of the cell, until the last column in the Total row.

6. Customize your table. Adjust the column and row sizes by dragging the edge of the cell containing the column/ row name. You may also change the line thickness of the border. You may also add colors for distinction.

7. When you're done, you can start typing your data to be computed.

8. Observe the results, look at the totals and see what you need to change in your budget plan.

9. Save your document:
a. Click the Office button
b. Select Save as
c. Select Excel Workbook
d. Type in your desired file name
e. Click Save.