Understand and use cell references

 1:44
 Cell references

 3:13
 Copying formulas
One of the key things you’ll calculate in Excel are values in cells, the boxes you see in the grid of an Excel worksheet. Each cell is identified by its reference—the column letter and row number that intersect at the cell's location. For example, a cell in column D and row 5 is cell D5. When you use cell references in a formula, Excel calculates the answer automatically using the numbers in the referenced cells.
Inside this course:
Cell references
(1:44)
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.
Copying formulas
(3:13)
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.
Course summary
A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.