Friday, August 21, 2009

Excel! Excel! Excel!

I think that when people think of college Excel is something that does not come to mind. Some would repute it as an accounting application, or something that is just not something they care for. HOWEVER, I recommend that you learn how to use this product, even the minor basics such as how to add or subtract without using a calculator or doing it in your mind, by applying the program's features.

My dad had me layout a budget for him on Excel. He wanted to know exactly how much money he would need to supply me with every month. Obviously on the quarter months the requirement would be much higher, but nevertheless he wanted to know exactly how much. I obviously was just thinking, 'Whattttt? I don't want to do this!' I'm glad I did.

USING EXCEL 101:

To lay out your budget...

1. Begin my labeling the "A" column with all the different types of bills you have, such as Room and Board, Tuition, Books, Supplies, Loans, Grants, etc... (Start this labeling from the second row, not the first).



2. Then label row one with all the months starting from column "B".


3. Then just fill in the numbers in the appropriate rows and columns. (Mind that these numbers are fake, AND REMEMBER to input the grant and loans as a negative number).


4. Now total up all of the amounts highlight the numbers from FEES down to THE EMPTY SPOT IN TOTAL and click the 'Auto Sum' near the top of the page.


This way you know how much money you will need every month in college, and you won't be short of cash since you planned ahead!

Sorry about the images. For Some reason it wont let me make them larger but click here to see them! :]

3 comments:

  1. Make the pictures clickable and enlargeable!!!

    ReplyDelete
  2. I agree. Make the pictures so that we can see it!!!!

    ReplyDelete