Excel I Formluae Microsoft Excel is a spreadsheet program. Spreadsheets are used to organize and store data in tables. Each square is called a cell, which can contain numbers, text, dates, or formulas. Excel is often (probably most often) used to keep track of income and expenses in households and businesses. In this tutorial, you will work on manipulating the data contained in a simple monthly budget.

1. Download the budget and open it in excel: https://www.dropbox.com/s/3e48oo26r5vaofc/Budget.xlsx?dl=0

If for some reason the link doesn't work, the budget is simply labeled Budget.xslx at the dropbox page.

2. Add up the fixed expenses by highlighting the column of dollar values and clicking the summation button at the top left of the screen. It looks like .3. Add up both the minimum and maximum variable expenses by doing the same.

4. Now for something more interesting.Calculate the average variable expenses by doing the following:

Click on the yellow cell beside the label Average Variable Expenses Type the following: =(C18+D18)/2 Hit enter You've just told excel to add the number in cell C18 and the number in cell

D18 and to divide the sum by two, finding the average. Yay

5. Now add up all the expenses to get the total expenses. You can save time by clicking on the cells you want to add up (or manipulate in general) instead of typing in their codes.Do the following:

Click on the red cell next to the label total expenses Type the equal sign Click on cell C9 (total fixed expenses) C9 should appear in the red cell Type the plus sign (+) Then click on cell D19 (average variable expenses) the red cell should now have the following: =C9+D19 Hit enter to get the sum

6. Now for income. As before, highlight the dollar amounts in the income section and click on the summation button to add them all up.

7. Find the net income by subtracting total expenses from total income you'll need to figure out this one on your own.

8. Finally, a demonstration of how excel updates itself when new data is added. We're going to add data for taxes and health. Both of these items should be in red text.

For taxes you need to calculate 10% of your total income. You do this by multiplying your total income by 0.10

For health, your minimum expenses are $20 and your maximum expenses are $100.

When you've added these data, your totals for expenses and net income should changeautomatically.