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]

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]

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.

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?

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.

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]

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

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]

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]

Originally Posted by Nidge

Accounts mate.

can you send me a copy of what you have. PM will be OK

Lee