Absolute and Relative Cell Referencing
Note: This video was originally the 3rd lesson in the plan, but due to the comments regarding it being too confusing at that level, I have moved it to the Intermediate section effective 3/23/17.
This video tutorial focuses on Absolute vs. Relative cell referencing within Excel. You likely know it as the dollar sign ($) used in functions/formulas (for example, C5 vs $C$5).
There is also a quick demonstration of the video using a VLOOKUP formula. The VLOOKUP formula is explained in more detail in these two lessons here and here, but the example in this video gives a basic understanding of how it works in Excel.
Update 5-22: I’ve noticed some users (especially those with Macs) have had difficulty viewing this video. Since it is one of the older videos, I will be re-recording it and adding information so that it is comparable to more recent videos.
If you’re following the Lesson Guide, next up is Math & Statistical Functions (e.g. SUM, AVERAGE)