Excel 2016: Referencing Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.



Expected Duration (hours)
0.8

Lesson Objectives

Excel 2016: Referencing Data

  • Referencing your cells
  • Using data across multiple worksheets
  • Choosing between absolute & relative cell references
  • Naming your data ranges
  • Performing calculations using constant values
  • Using cell references indirectly
  • Keeping an eye on your data
  • Activating automatic updates
  • Using formula auditing
  • Understanding formula errors

    • Course Number:
    ds_msex2016_08_enus

    Expertise Level
    Intermediate