Video: Cell references

Watch this video to learn the basics. When you use cell references in a formula, Excel calculates the answer using the numbers in the referenced cells. When you change the value in a cell, the formula calculates the new result automatically.

Other videos in this course

This video is part of a training course called Understand and use cell references. You can download the entire course or watch the videos online:

  1. Video: Cell references. (You are here!) Watch this video to learn the basics. When you use cell references in a formula, Excel calculates the answer using the numbers in the referenced cells. When you change the value in a cell, the formula calculates the new result automatically.
  2. Video: Copying formulas. We just saw how to create a formula that adds two cells. Now let’s copy the formula down the column so it adds the other pairs of cells.

Need a reminder of what you learned? See the course summary.

Ready for another tutorial? See the complete list of Excel 2013 training courses.

Rating:
Applies to:
Views:
45381
Submitted on:
22/06/2013
Length:
00:01:44