Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007
Resolved · Low Priority · Version Standard
Kelly has attended:
Excel Introduction course
Can you tell me more about the basic functions, when would be best to use Excel?
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 handleFirstly, 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. |
We'll call during UK business hours
Server loaded in 0.08 secs.