Highline Excel 2013 Class Video 05

Cell References: Relative, Absolute & Mixed (8 Examples)

DESCRIPTION

(01:09) Relative Reference Example, Net Income Formula.
(02:02) Ctrl + Enter to populate a range of cells with a formula.
(02:20) Relative and Absolute Reference Example, Increase Price Formula.
(04:29) Ctrl + Period ( . ) to jump to each corner of a highlighted range.
(05:00) Relative and Absolute Reference Example, Commission Formula.
(05:51) A. Relative and Absolute Reference Range Example, SUMIFS formula for adding with one condition. Top of sheet CR(4).
(07:56) Mixed Cell Reference Example, Income Statement Budget Example.
(19:23) Mixed Cell Reference Example, Multiplication Table Example.
(22:47) Mixed Cell Reference Example, Cross Tabulated Table with SUMIFS formula for adding with two conditions (criteria). Bottom of sheet CR(4).
(28:34) Mixed Cell Reference Example, Future Value (Value of pension example).

WORKBOOKS