Excel 2007

Resolved · Low Priority · Version Standard

Mon 10 Mar 2008, 16:51 Delegate Kelly said...

Kelly has attended:
Excel Introduction course

Excel 2007

Can you tell me more about the basic functions, when would be best to use Excel?

Fri 14 Mar 2008, 11:43 Trainer Mark said...

RE: Excel 2007

Hiya Kelly

How are you today, hope you enjoyed the training course on Monday

The answer to your question about basic functions there are some examples below for you to look at and try them out

=b3+b4+b5+b6+b7+b8 will add up the cells
=sum(b3:b8) will do the same as above & easier to write
=average(b3,b7,g10,h5,d9) will calculate the average of the cell
=sum(b3,b7,g10,h5,d9) will do the same as the average but will add them up

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please click reply or post it as a new question and we should be able to answer that!!

Hope this helps

Mark East
mark@stl-training.co.uk

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips

Excel 2007

Excel 2007

RE: Excel 2007

Excel articles

Excel tip:

Deleting a range of cells using the autofill handle