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:
Maikakapit sa:
Tumingin:
45874
Isinumite noong:
6/22/2013
Haba:
00:01:44