Part 1 – Income and Expenses
In this assignment, you will be creating an Excel worksheet to show your MONTHLY (January – December) Expenses and income.
(See the MyBudget.jpeg file attached – screenshot of what a sample monthly budget could look like. You can keep or change the items for Expenses and the items for Income.)
Be sure you have the months labels and the items of each Expense and type of Income.
Once you have filled in data (highlighted in yellow), you are ready to total the Expenses by month (columns), and then for each Expense item (rows). You may use addition formula or the SUM function.
Now, do the same for the Income range of data. Total the Income by month (columns) and for for each type of Income item (rows).
Part 2 – Difference between Income – Expenses
Now, we are ready to see the difference between your Income minus Expense. Compute this by MONTH (for example for January only, total Income minus total Expense for January). If it is a negative number, that means you did not earn enough to cover expenses for that month.
Now, copy the formula to find the differences for months February – December. You will see my results for this calculation by again, looking at the attached MyBudget.jpeg file. What does this data tell you? Did you make enough to cover your expenses?
For fun, I applied Conditional Formatting, to the row of differences between the Income (how much you made) – the Expenses, for any value that was less than 0. See how the red color brings attention to the reader of the worksheet?
Part 3 – Chart
Now, select an item (row) to chart. It can be the difference between Income and Expenses, or perhaps your income for a certain item, let’s say your wages for the months Jan – December.
Note, select the labels (months Jan – Dec) by highlighting it, THEN, click on the CTRL Key on your keyboard, then the row of data cells you wish to chart. If it is the row for Wages, then select that row of data across months Jan – December.
Now, Insert Chart, and select your chart type. You can place the Chart on this same worksheet. What did you learn by charting this item?
0 comments