Karl`s PC Help Forums Last active: Never
Not logged in [Login ]
Go To Bottom

In memory of Karl Davis, founder of this board, who made his final journey 12th June 2007

Post Reply
Who Can Post? All users can post new topics and all users can reply.
Username   Need to register?
Password:   Forgot password?
Subject: (optional)
Icon: [*]
Formatting Mode:
Normal
Advanced
Help

Insert Bold text Insert Italicised text Insert Underlined text Insert Centered text Insert a Hyperlink Insert E-mail Hyperlink Insert an Image Insert Code Formatted text Insert Quoted text Insert List
Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On
:) :( :D ;)
:cool: :o shocked_yellow :P
confused2 smokin: waveysmiley waggyfinger
brshteeth nananana lips_sealed kewl_glasses
Show All Smilies

Disable Smilies?
Use signature?
Turn BBCode off?
Receive email on reply?
The file size of the attachment must be under 200K.
Do not preview if you have attached an image.
Attachment:
    

Topic Review
LSemmens

[*] posted on 29-6-2009 at 11:41
What do you need to do, I've had lots of practice in programming excel.

A simple formula can be placed in one cell which refers to the value in another cell. so you could have a 1 in cell A1 and a 10 in cell A2 in cell B6 you could have a formula =A1+A2 which would then display the number 11, if you choose to change the value in either A1 or A2 see what B6 gives you. That is basically what Excel is good at. You can also use it for a simple database and sort on various columns.

As has been suggested, follow help, it has some excellent tutorials, If you know that a program can do something, in many cases all you need to do is ask it the right questions. IIRC in the original install of excel there were some excellent sample spreadsheets that do display the power of the program. Otherwise, ask here, one of us should be able to point you in the right direction.
delanti

[*] posted on 27-6-2009 at 23:17
I have Excel but rarely use it. Most of my spreadsheet work is fairly simple used for keeping records of supplies bought, rental income and so forth.

I use the spreadsheet that is included with Microsoft Works 8.5. It has a nice thing under tools called easy calc. You just tell it if you want to add, subtract or what ever and highlite the entries you want and it about does it for you. It is nice if you decide you want to quickly do an additional calculation at any time.waveysmiley
Topcat

[*] posted on 27-6-2009 at 18:06
Quote:
Originally posted by Nimuae
This has been on my PC for years and must be full of cobwebs by now! I would really like to start using it - but am confused about the mechanics of the thing.

Does anyone have a list of useful formulae that they would care to share? A sort of idiots guide of how to do ...

Percentages
Multiplication
Subtraction

etc.,


A good place to start would be in the help section, they tell the how and what with some good examples. just go to search and type in a key word, like percentages.
either that or post a specific task that you want to undertake and I'm sure someone will be able to post a working solution

Topcat.
Nimuae

[*] posted on 27-6-2009 at 09:24
This has been on my PC for years and must be full of cobwebs by now! I would really like to start using it - but am confused about the mechanics of the thing.

Does anyone have a list of useful formulae that they would care to share? A sort of idiots guide of how to do ...

Percentages
Multiplication
Subtraction

etc.,