Beginner's Guide to Programming - guidetoprogramming.com

  • Increase font size
  • Default font size
  • Decrease font size

Spreadsheet Tutorial 1 - A simple budget

We are going to use a simple home budget as a tutorial.  This is not meant to be an exhaustive home budget, but a basic start to a budget to demonstrate some spreadsheet features.

Open a new spreadsheet and save it as "tutorial spreadsheet 1". 
For 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).
Enter the following in cell A1: Monthly Budget
Note: cell A1 refers to column A row 1.  This is the top left cell on the spreadsheet, right under the A and to the right of 1.  If this doesn't make sense to you yet, it will become clearer to you as you work with spreadsheets more.  Eventually, it will become second nature to you!
In Cell A3 (skip cell A2): Monthly Income
A5: Expenses
A6: Rent
A7: Electric
A8: Heat (Gas/Oil)
A9: Cable
A10: Car Insurance
A11: Car Payment
A12: Gas
A13: Phone
A14: Cell Phone
A15: Total Expenses
Skip A16
A17: Net Per Month

Move the mouse pointer until you are on the line that is in the gray areas between the column headers A and B.  Your cursor should change into a line with two arrows pointing left and right.  If you click and hold the mouse down, you can resize the column by moving the mouse.  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.

Now, we are going to enter some numerical data in column B.  Some of this will seem obvious, but I'll spell out each item.
In Cell B3: Enter your total monthly income.  For Example "1,800" - without the quotes - would be a legitimate entry.  Don't enter "1800/mo" or anything else with text - we only want numbers in column B!
Skip B4 and B5
B6: Enter your monthly rent
B7: Enter your monthly electric bill
B8: Enter your monthly bill for heating
B9: Enter your monthly cable bill
B10: Enter your monthly car insurance bill
B11: Enter your monthly car payment
B12: Enter your monthly bill for gas for your car
B13: Enter your monthly phone bill
B14: Enter your monthly cell phone bill
Skip B15, B16 and B17 for now

Ok, now we have our basic data in the spreadsheet - let's do some calculations! 

In cell B15 type in (without the quotes) "=sum(B6:B14)".  Note that the letters aren't case sensitive, you could enter "=sum(b6:b14)" or "=SUM(B6:b14)" and it will work the same.  Once you type in the second parenthesis, hit Enter.  B15 should now display the total of your monthly expenses.  Congratulations, you have completed your first spreadsheet formula!

In cell B17 type in "=B3-B15".  Cell B17 should now display the difference between your income and expenses.  Hopefully, this number is positive!

Notice now you can go back and change your income or expenses, and the calculated totals will change automatically - this is one of the many powerful features of spreadsheets!  Once you design your data and calculations, you can change your data and see the results instantly!