BleepingComputer.com: Microsoft Excel 2003

I want a financial thing with excel but i tried to do one from a magazine but can't follow it.
below is sort of what i want. i would post in a picture but no options is there.


January February all through to December
Busget Actual
Income Partner 1
Partner 2
Other

Total Income

Exspenses Rent/House
Food
Insurance
Phone
Electricity / Gas
Credit Card
CLothes / Personal
Motor
Total Expenses
Net Gain/Loss

is there somewhere i could get a template already done?

I could do one for you in a short time.
1. Is Budget Actual to be added to the three incomes, or is it a unique entry
2. Do you want a year total?

John

I have one completed; let me know where to send it.
Cheers,
John

This post has been edited by jgweed: 31 January 2005 - 11:08 PM

i have a magazine which has it in but i can't post the image in.

But it's for 2 incomes.

Sure if you can get it working.

Each Month Jan, Feb, March, Apr, May, Jun, July, Aug, Sep, Oct, Nov, Dec

Is there a way i could post the image in?

there's 2 pages complete with instructions of the way i want it.

If not. you can have a go with the info.

Cell data is

A4 - Income
A7 - Total Income
A9 - Expenses
A18 - Total Expenses
A19 - Net Gain/Loss
B4 - Patner 1
B5 - Partner 2
B6 - Other
B9 - Rent/House Payments
B10 - Food
B11 - Insurances
B12 - Phone
B13 - Electricity / Gas
B14 - Credit Card
B15 - CLothes and personal
B16 - Motor
B17 - Sundry
B20 - Bank
C3 - Jan - D3 - Feb and so on

they are the cell entries.

please let me know if you need more info. It would be easier to post in the two pages though. they are on my hardrive. But good luck.

This post has been edited by Izzy: 31 January 2005 - 11:12 PM

The one I built has the months across the top, with income and expence items down the side, and subtotals for both, as well as a net total at the bottom. Let me know privately to what address to Email it to you.
Regards,
John

i am unsure to post my e-mail address on here as all users can view it. is there another way of making it unavailble to anyone except you?





i won't be able to post another message until tomorrow.

This post has been edited by Izzy: 01 February 2005 - 12:28 AM

Send me a PM here at BC.
Cheers,
John

Spreadsheet sent. If you have questions or need changes made, let me know by PM or Email.
Cheers,
John

Thanks.

That is only thing i don't understand with Excel. Creating the formular so when you type in amounts it's all totaled up easily. I'll need to do a small course or something. Once i get to know how to do it it will become easy after that, I can't believe there are still users of office 97. You should upgrade to 2000 at least as it is still being supported. BUt by means there is no major changes really. And saves $$$ with M$. I have Office 2000 Premium (i have lost disc 2 with publisher), i still have my Office XP Professional. As they have been used on this computer i'm using i am unable to do anything with them except throw them away. As only allowed to install it on 1 PC. As Office XP doesn't require activation, i was thinking of saving $$$. i was going to get a second PC just a cheap one (new) but cheaper ones for the internet. And i would put it on that. And keep the good one virus free. Keeping a virus thingy on it to scan discs etc.

But thanks again for the Excel sheet.

Izzy.

I have Office 97 on my spare computer, and I use the latest OO.o on this one. I see no sense in upgrade Office since 97 has all the functionality needed to create a decent spreadsheet, and without the bloat of later versions.

Learn to use the Auto Sum ( the greek Sigma) on the tool bar. In Excel, the standard toolbar has a button that simplifies adding a column or row of numbers. The Auto Sum button will automatically create a SUM( ) function. When you click the Auto Sum button, Excel creates (or "guesses) a sum function for the column of numbers directly above or the row of numbers to the left of the active cell (a blank cell will stop it). Excel then pastes the SUM( ) function and the range to sum into the formula bar; once the range is entered, press the Return key.

Regards,
John

Oh ok. i will give it a go. i'll try that out.

...I prefer the look of office than open office. (Shocking i know. and could have saved $1000 on office xp & 2003. (Office 2000 came with PC 11 months ago free as they had found old stock. done 2 upgrades in office in that time. i didn't know there was a 2003 til about 3 weeks ago. I would have gone 2000 to 2003 and saved $500 at least. there will probably be a 2005 this year or early 2006. but i won't be upgrading to it as it will be exactly the same. only an upgrade for small business. there was an article on MS website. So its 2003 'till the next major upgrade probally 2007/2008.

Izzy.

This post has been edited by Izzy: 01 February 2005 - 03:58 PM

The next version of Office will apparently concentrate on workflow functionality with a release date earlier than 2007.
Cheers,
John

I found an excellant (pun intended) site that will help you out on everything on this application. You can even filter different year's versions.

excel tips

Good find,JEservices.
Thanks,
John

You might also want to try the Office Templates section of www.microsoft.com

I've had mixed results getting the templates I needed from this site, but it's a good place to start.