AutoSum

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

Resolved · Low Priority · Version Standard

AutoSum

Marika has attended:
Excel Intermediate course
Powerpoint Introduction course

by - delegate Marika [1 post] (2008 Feb 14 Thu, 16:19) Reply

Can you only access/find AutoSum in the toolbar or can it also be found in one of the menu options?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: AutoSum

by - trainer Pete platinum contributer [600 posts] (2008 Feb 15 Fri, 09:28) Reply

Hi Marika, Thank you for your post, In answer to your question, the Autosum command (Sigma) on the toolbar is a shortcut to the 'Big Five' Sum, Count, Average, Max and Min, at the bottom of the menu (found by clicking on the drop down arrow) you will see the option more functions, this will open the More Functions dialog box which allows you access to all of Excel's functions, the More Functions dialog box can be accessed from the fx button on the Formula bar, but sadly in answer to your question no it is not available as one of the standard menu options. I hope that answers your question, best regards Pete.

· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Tap the Power of Recorded Macros with MS Excel Courses
· Microsoft Excel's Best Kept Secret
· Microsoft Excel Training - Numerical excellence for all

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips