How to Create a Personal Budget Using Excel 2007

Create a personal budget in Excel 2007 by using the template gallery.

Excel 2007 includes access to the Microsoft Online Template Gallery. This gallery has hundreds of templates for your business and personal needs. Creating a personal budget by downloading the template from the gallery and adding your personal information to the template. This template can then be used as a workbook or saved as a new template to be used at a later time.

Instructions

1. Open Excel 2007 and select the "Office" button. Select "New." Excel displays the templates available. Click on the word "Budgets" in the left task pane. Review the available templates and download one of the personal budgets by clicking the "Download" button.

2. Update your personal budget by adding your income. Locate the income section of the template and add your income. Locate the expense section of the template and add your expenses. If necessary, right click on the row and select "Insert Row" to add additional rows to the template.

3. Save your changes to the budget by clicking the "Save" icon in the Quick Access Toolbar.

References

• Microsoft: Template Gallery