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

Templates

ResolvedVersion 2003

Thu 29 Jan 2009, 17:17 Delegate Prakash said...

Prakash has attended:
Project Intro Intermediate course
Excel Intermediate course

Templates

How many templates can you reasonably use?

Fri 30 Jan 2009, 15:38 Trainer Maggie said...

RE: Templates

Hi Prakash,

Thanks for your question and welcome to the forum.

The number of Templates you can reasonably use at one time is only effected by your computers memory, but provided this is not an issue you can use/save as many as you require.

Thanks and kind regards

Maggie

Fri 30 Jan 2009, 16:33 Delegate Prakash said...

RE: Templates

Hi Maggie,

Thank you very much for the course. I found it really useful. Good luck with your plans later this year.

Prakash

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

Templates

Templates

RE: Templates

RE: Templates

Excel articles

Excel tip:

Sum Up All the Values in A Column