Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

templates

ResolvedVersion 2003

Prakash has attended:
Project Intro Intermediate course
Excel Intermediate course

Templates

How many templates can you reasonably use?

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

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.