excel training courses london - Advanced formulas

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

Resolved · Low Priority · Version Standard

Advanced formulas

Addy has attended:
Excel Advanced course
Excel Intermediate course

by - delegate Addy [3 posts] (2007 Mar 21 Wed, 09:46) Reply

how to i get an average for a column of figures

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

Average() function in excel

by - trainer Rich platinum contributer [744 posts] (2007 Mar 21 Wed, 14:02) Reply

Hi Addy,

There is an AVERAGE() function in excel which will do this for you.

Simply enter the range in the brackets.
Eg. =AVERAGE(F14:F31)

You can then format the cell that contains the forumla however you like (reduce number of decimal places etc.)

I hope this helps.

Regards, Rich

· Training Budgets In A Bad Economy
· Why Should I Learn Visual Basic in Excel?
· Benefits of learning about Excel charts
· Microsoft Excel Training: Essential for Today's Employees
· Improve Performance Of Your Excel Macros

Excel tip:

Closing all your workbooks Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open.

View all Excel hints and tips