Microsoft Excel: Using Absolute References ($) in Formulas
An Absolute Reference (e.g. $A) is one of the most powerful elements of using formulas in Excel. Many people see them, or use them, without really being sure why. This session goes in depth into what the $ is used for, why it is necessary and when to use it.