microsoft excel training courses london - Excel Formulas

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

Resolved · Low Priority · Version Standard

Excel Formulas

Yvette has attended:
Excel Advanced course

by - delegate Yvette [1 post] (2006 Nov 22 Wed, 09:40) Reply

1) What is the formula entry to get and average of a column of figures

2) What is the formula entry to get the highest number to appear from a column of figures

3) What is the formula entry to get the lowest number to appear from a column of figures

Thanks in advance

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Excel Formulas

by - trainer Orok bronze contributer [29 posts] (2006 Nov 22 Wed, 10:11) Reply

Hi Yvette,

In response to yur query,

In each example, first place your cursor where you want the result of your calculation to be displayed.

1) The formula to get the Average of a column of figures is =AVERAGE(A1:A10)
Where A1: A10 represents a column of cells containing the figures that an average is required for.

2) The formula to get the Highest number in a column of figures is =MAX(A1:A10)
Where A1: A10 represents acolumn of cells containing the figures that highest is required for.

3) The formula to get the Lowest number in a column of figures is =MIN(A1:A10)
Where A1: A10 represents a column of cells containing the figures that lowest is required for.

Hope this helps

· Microsoft Excel Courses Teach Advanced Macro Techniques
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· How to Create Better Excel Spreadsheets: Part Four
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· How to Create Better Excel Spreadsheets: Part One

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips