Dollar signs

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

Resolved · Low Priority · Version 2003

1 post

ReplyFri 19 Jun 2009, 16:34Delegate Laura said...

Laura has attended:
Excel Intermediate course

Dollar signs

Further explanation of dollar signs required.

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Fri 19 Mar 2010	Bloomsbury	0	FULL
2003	Wed 24 Mar 2010	Limehouse	7		£212	£217
2007	Fri 26 Mar 2010	Rochester (Hoo)	0	FULL
2007	Mon 29 Mar 2010	Bloomsbury	2		£235	£240
2003	Wed 31 Mar 2010	Southwark	7		£219	£224
2007	Tue 6 Apr 2010	Limehouse	5		£235	£240
Full Schedule: See all 70 Excel Advanced course dates. Bookings currently available until 22nd December 2010.

870 posts

ReplySun 21 Jun 2009, 06:25Trainer Rajeev said...

RE: Dollar signs

Dear Laura

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

Please find the below link to help you with general understanding of the Relative and Absolute (dollar signs) referencing in Excel:

http://www.homeandlearn.co.uk/me/mes9p1.html

http://www.free-training-tutorial.com/shortsum/formulas-taxShortsum.html

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 29 Jun 2009: Automatically marked as resolved.

· Reasons Why VBA for Excel Training Fails
· Correct In, Garbage Out
· From the Classroom to the Corporate World
· Improve Performance Of Your Excel Macros
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips

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

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips