Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Excel Advance

excel training microsoft - Excel Advance

ResolvedVersion Standard

Fri 11 Jan 2008, 11:10 Delegate Mariagiulia said...

Mariagiulia has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Excel Advance

In the Naming range for ormulas, if you name the range and you want to change it after finished the formulas, how can you do it? E.G. I have named the range cell_00 and I wnat to call it Sales_00, how do I do? Thanks

Fri 11 Jan 2008, 14:58 Delegate Paul said...

RE: Excel Advance

Insert > Name > define.

It should automatically update your formulae once the cells have calculated. Alternatively, if you have calculation set to manual (you can check this by going tools > options... and selecting the 'calculation' tab) then press F9 and the formulae will update

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 training microsoft - Excel Advance

Excel Advance

RE: Excel Advance

Excel articles

Excel tip:

Sum Up All the Values in A Column