Formulas

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

Resolved · Low Priority · Version Standard

Formulas

Latisha has attended:
Excel Intermediate course

by - delegate Latisha [1 post] (2008 Mar 17 Mon, 16:59) Reply

what are dollar signs for?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: formulas

by - trainer Pete platinum contributer [864 posts] (2008 Mar 18 Tue, 09:09) Reply

Hi Latisha, Thank you for your post, Welcome to the Forum, I hope you enjoyed your Excel Intermediate Course, in answer to your question, the dollar signs in a cell reference indicate that the reference is absolute, in other words it will not allow the formula to relatively update as the focus is moved to another cell, think of it as putting a pin through the cell reference to keep focus on it. I hope that answers your question, best regards Pete.

· A Beginners Guide To Formulas In Excel
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Fun Things I've Done With Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· What's Better Than the Help Function in Excel? Microsoft Training

Please browse our web site to find out more about
microsoft-excel-training and other Microsoft training courses.