microsoft+excel+training+london - Formula's using the $ symbol

the $ sign is used for when you want to 'drag out' a formula over many many cells, but keep the cell reference in the formula the same.
For instance, you have a figure in cell C1 that is a 'target' for salespeople to hit and you have a list of all the salespeople's actual scores in column A

type the following formula in cell B1 to keep referencing C1:

=$C$1-A1 and drag the formula down column B

Hope this helps

Paul