Course details

Excel 2019: Referencing Data

Excel 2019: 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, and formula auditing in Excel 2019.



Expected Duration (hours)
0.7

Lesson Objectives

Excel 2019: Referencing Data

  • reference cells in your Excel worksheet
  • use data across multiple worksheets to reference data for formulas
  • define absolute and relative cell references
  • create named ranges to refer to data and facilitate calculations
  • use the Name Manager to visualize, edit, and delete existing named ranges
  • perform calculations using constant values
  • use cell references indirectly
  • monitor data entries for changes and errors
  • activate and configure automatic updates
  • use formula auditing tools to track data
  • Course Number:
    ds_msex2019_11_enus

    Expertise Level
    Intermediate