Course details

Excel Office 365: Referencing Data

Excel Office 365: 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 for Office 365.



Expected Duration (hours)
0.8

Lesson Objectives

Excel Office 365: Referencing Data

  • reference cells in your Excel worksheet
  • use data across multiple worksheets to reference data for formulas
  • define absolute and relative cell references
  • name data ranges to refer to date 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_msex365_11_enus

    Expertise Level
    Intermediate