Cell References: Relative, Absolute & Mixed (8 Examples)
by
Video Lecture 5 of 50
Not yet rated
Views: 1,066

Lecture Description

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)

Course Description

This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. It contains 50 video lectures teaching the basics of Excel, as well as advanced concepts.

Be sure to download the workbook to follow along with the examples. They are found on the official course website.