Kingwood Underground
the heart and soul of our Kingwood, Texas family
Login - Create Account - Help
Clean out your garage on Kingwood bookoo! Or find local garage sales on Yard Sale Search.com
KU Live!

Has anyone here used excel...

who's talking here?

Carla 1
BrookleighPhotography 6
Cicero 1
WRM 7

     » send to friend     » save in my favorites     » flag dangerous topic flag as a dangerous topic

BrookleighPhotography --- 19 years ago -

For tracking your money and such? 

WRM --- 19 years ago -

I use Excel almost every day at work. 

BrookleighPhotography --- 19 years ago -

I am trying to put all my bills and expensies and such on there so i can use that kinda like a check book balance book. But i have only figured out how to add funds not subtract lol. Apparently im not so good at this. 

WRM --- 19 years ago -

Are you trying to put in a formuula which will calculate automatically for you? If so what you need to do is go to the cell that you want your answer to appear in and enter the plus sign. Then take your mouse pointer and click on the cell that contains the furst number you want to use in your formulas. You will then press either the addition or subtraction sign depending on which you want it to do, then use your pointer to click on the cell containing either the second number you are wanting to either add or subtract. One you click the second cell then hit enter. it should take you back to the original cell where you wanted the answer to appear and the correct answer should be there. Hopefully that makes since. if not let me know. 

BrookleighPhotography --- 19 years ago -

You rock! Lol i had to take it step by step but i got it! Thanks so much :) 

WRM --- 19 years ago -

I am glad I could help!! 

Carla --- 19 years ago -

I use Pear Budget, which is a premade Excel spreadsheet for a budget. But I use Quicken for what you're talking about. You could set it up like this: Columns for Date, Check Number, Cleared, Payee, Expense Category, Deposits, Payments, and Totals. If Deposits, Payments, and Totals are columns F, G, and H, in the Totals Column (H), you would put =H1+F2-G2 H1 is the beginning or previous balance, so the total would be that plus your deposits, minus the payments. Copy that formula into the rest of the cells in the H column, the cell rows automatically update. 

WRM --- 19 years ago -

by the way if you are wnating this formula to carry down in a column or across in a row you can just copy and past and it will automatically adjust the fomula for you. You can play with it and see what I am talking about, it's a pretty cool function. You don't have to redo the formual every time. 

Cicero --- 19 years ago -

You should look into Microsoft Money. I've been using it for 7-8 years and I love it. It even downloads my statements and reconciles for me. http://www.microsoft.com/money/default.mspx 

BrookleighPhotography --- 19 years ago -

ok now you have lost me WRM lol. I will have to take it slow. Im good with computers but this is new to me LOL. So say i have like 15 bills listed can i subtract more than just 2 columns? like for ex. Electricity= 318.92 house note-975.00 cable-119.00 and so on.. ( just making up #'s lol) how can i get a Total of more than just 2 #'s does that make since? 

WRM --- 19 years ago -

You do it the same way you will clik on each cell you want to include in your formula and between clicking each cell you enter either the addition or subtraction sign. Once you have completly selected all the numbers (or cells) you wish to include in your fomula then you click enter to take you back to where you want your answer. You can use two numbers or two hundred. Just use the same concept and when you are ready for the answer to appear in your original cell just press enter. let me know if that makes since or helps make thing clearer. 

BrookleighPhotography --- 19 years ago -

i got it thanks so much :) 

WRM --- 19 years ago -

You are very welcome. I am glad I could help. 

BrookleighPhotography --- 19 years ago -

:) Now i am going to try and get ALL the bills and such on there and in diff colors so i can keep track of them better lol. 

WRM --- 19 years ago -

I do balance my checkbook with Microsoft money hower I am like you i have a personal household budget that I do weekly that I keep on excell spreadsheets. I know exactly each week how much to put back so that when my bills come due i will have enough to cover them as well as it tells me how much extra money I have to spend that week after all is put up for bills. I do it weekly because we get paid weekly. I like it because I know exactly what I can spend and not spend and still get the bills paid. I would be lost finacially without it. 

page 1
Login to add your comments!

see more discussions about...

rant


Online now:
hit counters

Terms of Service - Privacy Policy - Ice Box

Kingwood Underground