One of the things I'm commonly asked for help with is creating a simple budget for a project or event. I've created this video to walk you through how to create one.
Here is a link to the sample budget that I created so that you can copy it and play with it if you want.
Below are the steps written out. See the video for a full explanation.
Below are the steps written out. See the video for a full explanation.
1) Go to sheets.google.com.
Sign in with your google account or register for one, if needed.
2) Press the new sheet button.
3) Change the title of your sheet, if you want.
4) In column A, enter the items on the budget.
5) In column B, enter the price for ONE of each item.
6) In column C, enter the amount of each item you need.
7) In column D, enter the units of each.
8) In cell E2, enter the formula: =B2*C2
9) Click on the little blue box in the lower right hand corner of E2 and drag the formula down.
10) In cell E6, enter the formula: =sum(E2:E5)
If your budget has more or fewer items, you would use the formula for all of those items, not just up to E5.
If you're only using local currency, then you're done!
If not...
11) Find your exchange rate. Enter it into H1.
12) In cell F2, enter the formula: =E2*H$1
Don't forget the $ sign if you're going to drag this down!
13) Drag the formula down to convert all of the rows.
14) (Optional) add formatting for clarification.
Your budget is done!!
