|
|
Featured Tutorial
Featured Macro
Excel Basics #8: Cell References Relative & Absolute
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#8 Video topics:
1)Cell references in formulas
2)F4 key to select the type of cell reference
3)Relative Cell Reference
4)Absolute Cell Reference
5)Mixed Cell Reference with column locked (Absolute Column)
6)Mixed Cell Reference with row locked (Absolute Row)
7)Fill handle double click trick for copying
8)Ctrl + Enter keyboard shortcut for entering many formulas at once
9)Formula for Percentage
10)Formula for periodic increase (increase each successive amount by 10%)
11)Formula function for Future Value
#8 Video topics:
1)Cell references in formulas
2)F4 key to select the type of cell reference
3)Relative Cell Reference
4)Absolute Cell Reference
5)Mixed Cell Reference with column locked (Absolute Column)
6)Mixed Cell Reference with row locked (Absolute Row)
7)Fill handle double click trick for copying
8)Ctrl + Enter keyboard shortcut for entering many formulas at once
9)Formula for Percentage
10)Formula for periodic increase (increase each successive amount by 10%)
11)Formula function for Future Value