Interesting Tips and Tricks relevant to important Program Functions and useful for daily tasks, are delivered to you every 14 days with our Special Topic.
Our current Special Topic:
Relative and Absolute Addressing in Excel
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.
Published on: 17.01.2023
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.)
Special Topics Archive:
Have you missed a Special Topic? Never mind, here you will find a complete list of all the Topics published to-date. Klick here on the required title to call-up the Special Topic.