Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Functions
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel+courses - Functions
Resolved · Low Priority · Version Standard
Reply Thu 8 Nov 2007, 16:07Delegate Anne said...
For upcoming training course dates see: Pricing & availability
RE: Functions
Dear Anne
Thank you for attending Excel Intermediate training with us.
Sometimes typing the Functions is easier and quicker than using the Paste Function dialog box.
Please note that structure of most of the statistical functions such as Average, MIN, MAX , COUNT, COUNTA and also SUM is as follows:
=Function Name(Cell Reference)
e.g.
=SUM(B3:B11)
=Min(B3:B11)
=Max(B3:B11)
=Average(B3:B11)
and so on...
Please note that:
- There is no space at all anywhere in the function.
- When you type the Function name it is not case sensitive so you can use all lower care or upper case.
- Min and Max are abbreviated but Average is NOT!!
- If the cells that you are performing the calculation on are together then use the :(Colon) as mentioned above. However if they are not together then please use the , (Comma) to separate them!!
Hope this helps
Kindest Regards
Rajeev Rawat
MOS Master Instructor
|