Saturday, March 16, 2013

How to Make a Budget on Excel 2007


1. Open Microsoft Excel 2007. Select the 'Office' button and click 'New.' In the 'New Workbook' dialog box, click on the 'Installed Templates' or 'Budget' group to find budget templates that are inbuilt into Excel.
2. Pick a template that works for you. Hit the 'Create' button to use the template.
3. Check out the data and structure of your template. Type in your monthly expenses by selecting the applicable cell and entering the correct data into the cell. Remove any data you don't need by selecting the applicable cell and hitting the delete key or deleting the entire row.
4. Change the monthly income to match your income. The budget will automatically deduct your expenses from the income column.
5. Save your newly created budget by clicking the 'Office' button and choosing 'Save.' Name your file in the 'Save As' dialog box and hit 'Save.' You may reuse the budget for upcoming months and re-save your file by clicking the 'Office' button and choosing the 'Save As' option.
Make a Budget on Excel 2007 from Scratch
6. Open Microsoft Excel 2007.
7. Create columns for your expenses, their projected cost and actual cost in your blank worksheet. Then place your expenses under each header.
Example:
Expense: Electricity
Projected Cost: 75
Actual Cost: 70
8. Enter all the expenses for each bill. Then place your cursor in the blank row just after the last entry of your 'Actual Cost' column. Use Excel's inbuilt formula to calculate the total for your monthly cost by clicking the 'AutoSum' button. Excel will highlight the cells that are being calculated in the 'Actual Cost' column. Hit 'Enter' to accept the calculations.
9. Create columns for your income and balance. Then enter your information under each header.
Example:
Income: 3480
Balance: (calculated automatically)
10. Calculate your balance for the month by selecting the blank cell below or beside the 'Balance' column and typing an '=' sign (no quotes) in the formula bar. Then click on the cell that includes your income and type a '-' sign (no quotes) in the formula bar. Click on the cell that includes your 'Actual Cost' total and hit 'Enter.' Your balance will now appear in the empty cell beside/under 'Balance.'
11. Double-check that your figures are correct and save your file (by selecting the 'Office' button and hitting 'Save.' Your Excel 2007 budget is now complete.

Blogger news