Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel versions

Resolved · Medium Priority · Version 2003

Reply Wed 21 Oct 2009, 16:21Delegate Vanessa said...

Vanessa has attended:
Excel Advanced course
Powerpoint Intermediate Advanced course
Powerpoint Introduction course

Excel versions

do the same commands in excel 2003 work in 2007 (e.g. setting up a pivot table) or is re-training required for 2007?

For upcoming training course dates see: Pricing & availability

Reply Fri 23 Oct 2009, 09:19Trainer Amanda said...

RE: excel versions

Hello Vanessa

Thank you for your question and welcome to the forum.

The functionality of Excel is the same across both versions, the main difference is how the interface looks. So re-training is not necessarily required, it just might take a while to find the features in 2007 that you are used to using in 2003.

You will be able to download the reference material for Excel Advanced for the 2007 version through your delegate account.

Kind regards
Amanda

Excel articles

· Do You Really Need Excel VBA Training?
· Tips From Excel's 'Rarely Used' File
· You're Hired! Raising Your Chances Of Employment With Excel
· Microsoft Excel Training: Essential for Today's Employees
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets

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

View all Excel hints and tips