Highline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples) скачать в хорошем качестве

Highline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)

Download workbook: http://people.highline.edu/mgirvin/Al... This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. Topics in this video: 1. Relative Reference Example, Net Income Formula (01:09 min) Ctrl + Enter to populate a range of cells with a formula (02:02 min) 2. Relative and Absolute Reference Example, Increase Price Formula (02:20 min) Ctrl + Period ( . ) to jump to each corner of a highlighted range (04:29 min) 3. Relative and Absolute Reference Example, Commission Formula (05:00 min) 4. A. Relative and Absolute Reference Range Example, SUMIFS formula for adding with one condition. Top of sheet CR(4). (05:51 min) 5. Mixed Cell Reference Example, Income Statement Budget Example (07:56 min) 6. Mixed Cell Reference Example, Multiplication Table Example (19:23 min) 4. B. Mixed Cell Reference Example, Cross Tabulated Table with SUMIFS formula for adding with two conditions (criteria). Bottom of sheet CR(4). (22:47 min) 7. Mixed Cell Reference Example, Future Value (Value of pension example) (28:34 min)