Microsoft Excel

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

Resolved · Medium Priority · Version 2003

Microsoft Excel

Jen has attended:
Excel Intermediate course

by - delegate Jen [1 post] (2008 Apr 17 Thu, 16:06) Reply

What is the formula to working out the average with certain cells on a spreadsheet

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Microsoft Excel

by - trainer David [15 posts] (2008 Apr 17 Thu, 16:31) Reply

Hi Jen

Type this in formula bar '=AVERAGE(A1:A5)'
if you wanted to get an average of cells A1 to A5.

You can also use the shortcut by clicking the dropdown function on the Autosum button on your shortcuts menu. It looks like a greek E.

Yet another way is to select the cell you want the average to appear in. Then choose Insert from the menu bar and choose Function... In the select function area choose AVERAGE. then click Okay. It will then ask for a range of cells. Simply click and drag the cells you want an average of. Then click Okay.

· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Crazy Things People Have Done With Excel
· Microsoft Excel Training: Essential for Today's Employees
· MS Excel: Excel At Making The Most Of Your Christmas
· An Introduction to Microsoft Excel: Top Features for the Excel Novice

Please browse our web site to find out more about
excel+training+best and other Microsoft training courses.

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips