Cable Forum

Cable Forum (https://www.cableforum.uk/board/index.php)
-   General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)
-   -   Excel help? (https://www.cableforum.uk/board/showthread.php?t=12344)

Nidge 14-05-2004 09:41
Excel help?
 
Need some help on how to use Microsoft Excel. I'm ok at using it but I need to now how to do a spreadsheet, add up and take away and all that.

skyblueheroes 14-05-2004 09:46
Re: Excel help?
 
Not an excel expert, but you basically need to produce some formulas in the cells you want.

So, for example, the formula would be =B3-B4. Or for a Sum of a number of cells =B1:B10.

I'm sure there will be some comprehensive help in Excel on Formulas.

lemarsh 14-05-2004 09:54
Re: Excel help?
 
Quote:
Originally Posted by Nidge
Need some help on how to use Microsoft Excel. I'm ok at using it but I need to now how to do a spreadsheet, add up and take away and all that.
Can you give am example of what you want it to do, and then I/we can have a look, come up with some suggestions, and advise what the spreadsheet is doing & why.

gary_580 14-05-2004 09:55
Re: Excel help?
 
Excels help will cover that in great detail.

not sure what you mean by "your ok with usig it" if you cant add and take away with it?

Nidge 14-05-2004 10:02
Re: Excel help?
 
Quote:
Originally Posted by skyblueheroes
Not an excel expert, but you basically need to produce some formulas in the cells you want.

So, for example, the formula would be =B3-B4. Or for a Sum of a number of cells =B1:B10.

I'm sure there will be some comprehensive help in Excel on Formulas.
Trying to do my accounts, I've got all the figures in rows all lined up correct now I need to add them and take them away.

Nidge 14-05-2004 10:03
Re: Excel help?
 
Quote:
Originally Posted by lemarsh
Can you give am example of what you want it to do, and then I/we can have a look, come up with some suggestions, and advise what the spreadsheet is doing & why.
Accounts mate.

Nugget 14-05-2004 10:04
Re: Excel help?
 
It depends what sort of info / presentation format you want to use - Excel's got quite a good help system anyway but, if you want to use your info for pie charts / bar charts etc, there's an icon on one of the toolbars that's like a little bar chart. If you press that, it should take you through setting it up.

The main thing to do is to make sure that your sums add up (but Excel will tell you if there's a mistake in any formulas.

Hope that helps Nidge :)

Nidge 14-05-2004 10:05
Re: Excel help?
 
Quote:
Originally Posted by Nugget
It depends what sort of info / presentation format you want to use - Excel's got quite a good help system anyway but, if you want to use your info for pie charts / bar charts etc, there's an icon on one of the toolbars that's like a little bar chart. If you press that, it should take you through setting it up.

The main thing to do is to make sure that your sums add up (but Excel will tell you if there's a mistake in any formulas.

Hope that helps Nidge :)

Cheers I'll take a look.

andygrif 14-05-2004 10:07
Re: Excel help?
 
The structure of the cell you want the total in should be as follows (say you want to subtract cell A2 from cell A1 in cell A3), you should type this in cell A3:


=sum(A1-A2)

If you wanted to add, then it's slightly different:

=sum(A1:A2)

You can also add multiple cells...eg if you want to add all the amount in cells A1 to A10 then your formula would beas follows:

=sum(A1:A10)

You can also do other features such as divide (/) or multiply (*) and percentages (*xx%) where xx is the percentage you want.

Let me know if you need any more info.

lemarsh 14-05-2004 10:09
Re: Excel help?
 
Quote:
Originally Posted by Nidge
Accounts mate.
can you send me a copy of what you have. PM will be OK

Lee


All times are GMT. The time now is 01:28.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum