Main Profile

At A Glance

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
Length: 10:03

Contact

Questions about Excel Basics #8: Cell References Relative & Absolute

Want more info about Excel Basics #8: Cell References Relative & Absolute? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question