No questions at the moment

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

· Low Priority · Version 2007

Danica has attended:
Excel Intermediate course

by - delegate Danica [1 post] (2008 May 9 Fri, 17:05) Reply

No questions at the moment

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course				List price £245
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 20 Tue	Bloomsbury	7	book now	£218	£240
2003/XP	2008 May 21 Wed	Southwark	5	book now	£219	£235
2003/XP	2008 May 21 Wed	Bayswater	6	book now	£195	£205
2003/XP	2008 May 23 Fri	Bloomsbury	6	book now	£214	£230
2003/XP	2008 May 30 Fri	Southwark	6	book now	£214	£230
2003/XP	2008 Jun 4 Wed	Bayswater	7	book now	£203	£230
Full Schedule: See all 153 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: No questions at the moment

by - trainer Tracy platinum contributer [586 posts] (2008 May 12 Mon, 00:55) Reply

Do not hesitate to post one in when you get any problems.
I hope you enjoyed your training.
Tracy

· Identifying Suitable Candidates For VBA For Excel Training
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Prepare for your MOS Certification with MS Excel Courses
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Tools From Advanced Excel Courses: Goal Seek and Solver

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

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

No questions at the moment

Related articles

Excel tip:

Sum Up All the Values in A Column