Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Microsoft Excel 2003


  • Please log in to reply
13 replies to this topic

#1 Izzy

Izzy

  • Members
  • 1,375 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Australia
  • Local time:01:26 AM

Posted 31 January 2005 - 09:23 PM

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?

BC AdBot (Login to Remove)

 


#2 jgweed

jgweed

  • Members
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:01:26 AM

Posted 31 January 2005 - 10:50 PM

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

Edited by jgweed, 31 January 2005 - 11:08 PM.

Whereof one cannot speak, thereof one should be silent.

#3 Izzy

Izzy
  • Topic Starter

  • Members
  • 1,375 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Australia
  • Local time:01:26 AM

Posted 31 January 2005 - 11:11 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.

Edited by Izzy, 31 January 2005 - 11:12 PM.


#4 jgweed

jgweed

  • Members
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:01:26 AM

Posted 31 January 2005 - 11:55 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
Whereof one cannot speak, thereof one should be silent.

#5 Izzy

Izzy
  • Topic Starter

  • Members
  • 1,375 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Australia
  • Local time:01:26 AM

Posted 01 February 2005 - 12:21 AM

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.

Edited by Izzy, 01 February 2005 - 12:28 AM.


#6 jgweed

jgweed

  • Members
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:01:26 AM

Posted 01 February 2005 - 12:35 AM

Send me a PM here at BC.
Cheers,
John
Whereof one cannot speak, thereof one should be silent.

#7 jgweed

jgweed

  • Members
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:01:26 AM

Posted 01 February 2005 - 02:09 PM

Spreadsheet sent. If you have questions or need changes made, let me know by PM or Email.
Cheers,
John
Whereof one cannot speak, thereof one should be silent.

#8 Izzy

Izzy
  • Topic Starter

  • Members
  • 1,375 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Australia
  • Local time:01:26 AM

Posted 01 February 2005 - 02:36 PM

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.

#9 jgweed

jgweed

  • Members
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:01:26 AM

Posted 01 February 2005 - 02:59 PM

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
Whereof one cannot speak, thereof one should be silent.

#10 Izzy

Izzy
  • Topic Starter

  • Members
  • 1,375 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Australia
  • Local time:01:26 AM

Posted 01 February 2005 - 03:57 PM

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.

Edited by Izzy, 01 February 2005 - 03:58 PM.


#11 jgweed

jgweed

  • Members
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:01:26 AM

Posted 05 February 2005 - 03:34 PM

The next version of Office will apparently concentrate on workflow functionality with a release date earlier than 2007.
Cheers,
John
Whereof one cannot speak, thereof one should be silent.

#12 JEservices

JEservices

    helping hand


  • Members
  • 1,700 posts
  • OFFLINE
  •  
  • Location:Texas
  • Local time:12:26 AM

Posted 05 February 2005 - 07:40 PM

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
We are all curious like a cat. We wonder, we ask, we learn.
Please post back when a suggestion works, so that others may learn.

#13 jgweed

jgweed

  • Members
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:01:26 AM

Posted 17 February 2005 - 09:01 AM

Good find,JEservices.
Thanks,
John
Whereof one cannot speak, thereof one should be silent.

#14 msc0421

msc0421

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Local time:01:26 AM

Posted 20 February 2005 - 07:22 PM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users