Dive into a comprehensive 40-minute video tutorial on cell references in Excel formulas, covering relative, absolute, and mixed references. Explore eight types of cell references, starting with relative references at 3:21 and absolute (locked) references at 5:00. Learn about mixed references with column locked (14:30) and row locked (20:29). Apply your knowledge to a practical example using the FV function at 5:30, and create a multiplication table using mixed references at 35:27. Perfect for Excel beginners and intermediate users looking to enhance their formula skills in Excel 2010 and beyond.
Overview
Syllabus
2. Relative minute mark
3. Absolute or Locked minute mark
4. Mixed with Column Locked, Row Not Column Absolute, Row Relative minute mark
5. Mixed with Row Locked, Column Not Row Absolute, Column Relative minute mark
6. Comprehensive example with FV function minute mark
7. Mixed Example for Multiplication Table minute mark
Taught by
ExcelIsFun
