Tip: if you type January and click on the small black box (fill handle) in the bottom right-hand corner of cell B2 and drag it across, it will fill in the rest of the months for you without you having to type them. Next, type the months along the next row, staring at B2. ![]() Start a new document and give it a heading like Budget. Make sure to customise the spreadsheet expense and income categories to your personal circumstances. Steps Building A Basic Home Budget Spreadsheetīelow are the steps, accompanied with diagrams, to creating a basic home budget. If you don’t have Excel, then the free alternatives ( Open Office or Google spreadsheets) are pretty similar and this tutorial should still be helpful the functions will just be in different menus. The tutorial is based on the latest version of Excel, so if you’re using the older version of Excel, you will find the same functions in the toolbar and menu bar. This tutorial starts from the very beginning for those who have never met a spreadsheet before. ![]() When you create your own budget yourself, you can customise it to meet your own needs and circumstances exactly. I have been using it now for over a decade. Excel is an awesome program for personal budgeting.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |