Training book

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

Resolved · Low Priority · Version Standard

Training book

Shehnaz has attended:
Excel VBA course

by - delegate Shehnaz [3 posts] (2008 Feb 14 Thu, 16:29) Reply

Is there a VBA Excel book that you would recommend as a guide to advanced VBA?

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: Training book

by - trainer David gold contributer [355 posts] (2008 Feb 20 Wed, 08:43) Reply

Shehnaz

Please address your enquiry to

info@microsofttraining.net

thanks

Best Training Team

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Microsoft Excel Features and Functions for Accountants
· Microsoft Excel Courses Teach Advanced Macro Techniques
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Database Tips from an Excel Training Course

Please browse our web site to find out more about
microsoft-excel-courses 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.