Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Exercises

Excel Exercises

ResolvedVersion 2003

Thu 11 Sep 2008, 16:16 Delegate Mark said...

Mark has attended:
Excel Intermediate course

Excel Exercises

Does the Excel application provide in house training excerises?

Fri 12 Sep 2008, 10:45 Trainer Greg said...

RE: Excel Exercises

Hi Mark,

Thank you for asking this question. Since I am very new to BEST Training, can you please clarify what you meant by "in-house exercises"?

BEST training do have the training support pack which was given to you when you came for your course. So you can practice from there. I do not know whether your training pack had a CD at the back of it or not.

I shall be very grateful if you would clarify your request so that we will be able to assist you more effectively.

Thank you very much

Greg Eze

Training courses

98.7 % recommend us

More live stats...

Training information:

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

Excel Exercises

Excel Exercises

RE: Excel Exercises

Excel articles

Excel tip:

Sum Up All the Values in A Column