How to Organize Finances As a Teen

Step-by-Step Guide

1. 1

   Step 1: Start by placing all your cards

   In Cell A1, type "Money in Wallet"
   
   then place the amount of money you have in your wallet in Cell A2. ,,,, Click on D4, then click on the small black box at the corner.
   
   Drag it down next to the bottom of the list of items you wish to buy. , Drag the small box at the bottom right corner until the coloured box covers the prices of the items you want, then click Enter. ,, Make sure to use the two brackets, this will be important if the spreadsheet expands.
2. 2

   Step 2: etc in your wallet.

3. 3

   Step 3: Count the money in your wallet

4. 4

   Step 4: then go back to your spreadsheet.

5. 5

   Step 5: In Cell B1 put "Money left to Distribute"

6. 6

   Step 6: but leave Cell B2 blank for now

7. 7

   Step 7: Start listing all the things you want (beginning in Cell A4

8. 8

   Step 8: ) that are less than £100

9. 9

   Step 9: in Row A

10. 10

    Step 10: with the prices of the items in Row B.

11. 11

    Step 11: In Row C

12. 12

    Step 12: place the amount of Money that you currently have that you are willing to distribute to that Item.

13. 13

    Step 13: In Cell D4

14. 14

    Step 14: input this formulae "=(B4-C4)".

15. 15

    Step 15: Below the items

16. 16

    Step 16: insert Totals in column A. Click on the cell next to totals

17. 17

    Step 17: then click on the strange E (autosum) in the toolbar.

18. 18

    Step 18: Click on the small black box and drag it across to row D.

19. 19

    Step 19: Finally

20. 20

    Step 20: go to Cell B2 insert =(A2 - ("insert the cell where the total price of the items you want is")).

Detailed Guide

About the Author