Monday, February 25, 2008

Tracking Expenses Part 2
(The Sequel)

You are continuing this from Tracking Expenses Part 1.

First add on 10 more days of tracking expenses all they way to March 20.

Now we have 20 days of tracking our budget.  We would like to find out how much is spent on each category of our expenses.  There are many different ways of doing this.  I'm going to show you the way that came to me.

1. Click on the cell B2. 

2. Hold the shift key down and use your arrow keys to move down to the last purchase on 20-Mar. 

3. Click Edit.

4. Click Copy. 

5. Click on the cell D2. 

6. Click Edit.

7. Click Paste. 

8. Select the new column of amounts and names of the categories. 

9. Click Data.

10. Click Sort. 

11. Make sure Sort by click Column E. 

12. Click Ok.

13. Now your chart will be organized alphabetically.

14. 

15. Now Lets sum up our expenses.

16. Click on the cell next to the word Automobile.

17. Click on the Auto Sum button. 

18. Click on the cell next to Automobile. 

19. Press the Enter Key.

20. Lets go to our next category which is Gas.

21. Click on the cell G3. 

22. Click Auto Sum. 

23. Use the arrow keys to go to the first amount next to gas. 

24. Hold the Shift Key and press the down arrow to cover all the gas. 

25. Press the Enter Key.