excel+courses - Functions

The UK's most regular instructor-led training courses.
Training information: excel+courses · Excel courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Functions

Anne has attended:
Excel Intermediate course

by - delegate Anne [1 post] (2007 Nov 8 Thu, 16:07) Reply

How do I manually type functions.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Functions

by - trainer Rajeev gold contributer [480 posts] (2007 Nov 11 Sun, 19:50) Reply

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

· Basic Excel Training
· From the Classroom to the Corporate World
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Microsoft Excel Features and Functions for Accountants

Excel tip:

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Excel hints and tips

Rate this page: