Title:
Excel Basics #8: Cell References Relative and AbsoluteVideo:
Description: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
Published:
17/Dec/2008
Excel Basics #8: Cell References Relative and AbsoluteVideo:
Description: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
Published:
17/Dec/2008
No comments:
Post a Comment