Excel 2013: Referencing Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

Increase your Excel 2013 mastery by learning about referencing cells, using data across worksheets, absolute and relative references, and named ranges. In addition, explore automatic updates, formula auditing, and formula errors.



Expected Duration (hours)
1.1

Lesson Objectives

Excel 2013: 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_msex2013_09_enus

    Expertise Level
    Intermediate