Browse » Home
Friday, March 23, 2012
How to Create a Simple Budget in Excel 2003
1. Gather your budget information. Have your monthly statements and expenditure amounts ready.
2. Double-click on the 'Excel' icon on your computer. If you can't find it on the desktop, open the program using the 'Start' menu on your toolbar.
3. Decide whether you want to make your budget from scratch or use a template. Using a template is the easiest method. If you're going to use a template, skip to Step 5.
4. Make your budget from scratch by setting up your worksheet any way you like. Start by naming the rows and columns and then add figures for various incomes and expenditures.
5. Click 'New' on the task bar on the top of the page to display a box with various different templates for projects in Excel. Select the simple budget template option. Follow the instructions and fill in the cells with your expenses and income.
6. Save your budget by pressing the 'Ctrl' and 'S' keys at the same time. You can also print it out by pressing 'Ctrl' and 'P.'
7. Update and change your budget as needed. Your Excel 2003 budget is fully customizable and can be changed based on your needs. You can even make graphs and charts from your data for visual assistance.