Excel 2010: Referencing Data

Excel 2010: Referencing Data

Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Overview/Description

To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.

Expected Duration (hours)
0.7

Lesson Objectives

Excel 2010: Referencing Data

Referencing your cells

Using data across multiple sheets

Choosing between absolute & relative cell references

Naming your data ranges

Performing calculations using constants

Using cell references indirectly

Keeping an eye on your data

Activating automatic updates

Using formula auditing

Understanding formula errors

Course Number:
ds_msex2010_08_enus

Expertise Level
Intermediate