Back to Blog
Step 5: Now we need to add your expenditure. Step 4: Then, put in a heading for your income and then below this any sub-headings for the type of income you receive, for example salary, pension, benefits. Type each month in an individual cell along one row of the spreadsheet. Step 3: Put in the months over which you want to budget to run. Excel will total up the income and expenditure for you. For a simple budget, we need to put in figures for ‘income’ and ‘expenditure’ (outgoings). Step 2: The spreadsheet needs to have information put in it, to calculate the figures for your budget. Step 1: Open up Excel so that you have a blank spreadsheet. This guide shows you how to create a budget spreadsheet in Microsoft Excel.įollow these step-by-step instructions to create a budget spreadsheet using Excel Using a budget in this way can be used for many different things such as preparing for Christmas. It also means that any changes to figures can be automatically updated in calculations by the spreadsheet so that it does all the hard work. Using spreadsheets to help you plan your budget can be useful because it can help with complex calculations and you can see at a glance incomings and outgoings.
0 Comments
Read More
Leave a Reply. |