Personal Expenses Excel

Tracking Personal Expenses

Format according to THIS EXAMPLE
USE YOUR OWN CATEGORIES AND AMOUNTS- DO NOT COPY MY EXAMPLE!!! BE CREATIVE :)
(SHOTGUN SHELLS, MAKEUP, ETC...)

1. Using this document as an example, create a hypothetical expense sheet for your monthly expenses in the spring semester (February through May). You may have whatever
and as many expense categories as you wish (e.g. gas, groceries, etc.) but you should have at least four and they should be somewhat related to the real world.

2. Format the cells with dollar values in them (B3:F6) in
Accounting format. (Select the cells :: Format :: Cells... :: Accounting [with 2 decimal places]).

3. Calculate the average for each category for the four months.

4. Calculate the total of all expenses for each month.

5. Create a pie chart for expenses in February.

Select A1:B5. Insert :: Chart... :: Pie :: Pie.

Add labels. Double-click the pie :: Labels :: Show category name and percent.
Move and resize the chart so it looks like the example.

6. Create a column chart for Gas in all four months.
Select A1:E2. Insert :: Chart... :: Column :: Clustered Column.
Add labels. Double click one of the columns :: Labels :: Show value.
Move and resize the chart so it looks like the example.

7. Create a line graph for the total of all expenses for the four months.
Select A6:E6. Insert :: Chart... :: Line :: Line.
To get the months to appear on the X-axis: Chart :: Source
Data... :: define Category (X) axis labels (click the symbol to the right of the blank field, click B1, shift-click E1, click the symbol to the right of the blank field again, Okay).
Change the title to "Total Expenses for Spring Semester."
(Click the title to edit it.)
Delete the key on the right. (Click the key, then hit Delete.)
Add labels. Double-click one of the series :: Labels :: Show value :: Label position: Above,
Move and resize the chart so it looks like the example (put it at the top of the second page.)