excel course - Absolute &Relative

The UK's most regular instructor-led training courses.
Training information: excel course · Excel/courses/london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Absolute &Relative

Hannah has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Hannah [3 posts] (2007 Mar 27 Tue, 09:53) Reply

What's the definition of the two?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Absolute &Relative

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 27 Tue, 10:36) Reply

Hi Hannah,

The book definition is as follows:-

A relative cell reference in a formula, such as A1, is based on a relative position of the cell that contains the formula and the cell the reference refers to. If the position of the cell that contains the formula changes, the reference is changed.

An absolute cell reference in a formula, such as $A$1, will always refer to a cell in a specific location. If the position of the cell that contains the formula changes, the absolute reference remains the same.

Hope that helps

Tracy

· Microsoft Excel Training: Not Just for Newbies Anymore
· Reasons Why VBA for Excel Training Fails
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Microsoft Excel Features and Functions for Accountants

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips