Cell B17 should now display the difference between your income and expenses. Congratulations, you have completed your first spreadsheet formula! B15 should now display the total of your monthly expenses. Once you type in the second parenthesis, hit Enter. Note that the letters aren't case sensitive, you could enter "=sum(b6:b14)" or "=SUM(B6:b14)" and it will work the same. In cell B15 type in (without the quotes) "=sum(B6:B14)". Ok, now we have our basic data in the spreadsheet - let's do some calculations! Don't enter "1800/mo" or anything else with text - we only want numbers in column B!ī10: Enter your monthly car insurance billī12: Enter your monthly bill for gas for your car
#Online simple home budget spreadsheet how to
For Example "1,800" - without the quotes - would be a legitimate entry. Download templates create your own budget spreadsheet, create your own budget template, make your own budget sheet, personal budget spreadsheet, how to create a business budget in excel, monthly. In Cell B3: Enter your total monthly income.
Some of this will seem obvious, but I'll spell out each item. Now, we are going to enter some numerical data in column B. In this case, I would like you to doubleclick on that line - it will automatically resize the column to the largest element in the column to the left, in this case column A. If you click and hold the mouse down, you can resize the column by moving the mouse. Your cursor should change into a line with two arrows pointing left and right. If it looks like something you need, just download a copy below: I tried to keep the spreadsheet as simple as possible, since that seemed to be what folks were requesting. Move the mouse pointer until you are on the line that is in the gray areas between the column headers A and B. Heres a shot of the second (blank) Simple Budget worksheet, nice and clean and ready to start you toward Budgeting Bliss: Nothing terribly complicated. In Cell A3 (skip cell A2): Monthly Income
Eventually, it will become second nature to you! If this doesn't make sense to you yet, it will become clearer to you as you work with spreadsheets more. This is the top left cell on the spreadsheet, right under the A and to the right of 1. Open a new spreadsheet and save it as "tutorial spreadsheet 1".įor the below cells in column A, enter the exact text I am telling you to enter, not the amount those might be (that is coming next).Įnter the following in cell A1: Monthly Budget This is not meant to be an exhaustive home budget, but a basic start to a budget to demonstrate some spreadsheet features. We are going to use a simple home budget as a tutorial.
0 kommentar(er)
