You might have wondered what the dollar sign means in some Excel formulae. Excel has two fundamentally different methods to make reference to cells in a formula. For efficient work with Excel, it is extremely important to know the difference between Relative and Absolute Addressing, so that the results will not be calculated incorrectly. We show you in this special topic, what the difference is between both forms of Addressing and how to use them skillfully.
To acces the videos for this Special Topic you must have subscribed to Excel !
Excel 2016
Absolute References:
In this video we explain the difference between absolute and relative cell references. Additionally we will show you how to use the absolute cell references when creating formulas.
(6 Min.)
Excel 2013
Absolute References:
In this video we explain the difference between absolute and relative cell references. Additionally we will show you how to use the absolute cell references when creating formulas.
(6 Min.)
Excel 2010
Absolute References:
In this video we explain the difference between absolute and relative cell references. Additionally we will show you how to use the absolute cell references when creating formulas.
(6 Min.)
Excel 2007
Absolute References:
In this video we explain the difference between absolute and relative cell references. Additionally we will show you how to use the absolute cell references when creating formulas.
(6 Min.)