Microsoft Excel 2016 for Mac: 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.6

Lesson Objectives

Microsoft Excel 2016 for Mac: Referencing Data

  • Referencing your cells
  • Using data across multiple worksheets
  • Choosing between absolute & relative cell references
  • Naming your data ranges
  • Activating automatic updates
  • Using formula auditing
  • Understanding formula errors
  • Course Number:
    ds_msex16mc_08_enus

    Expertise Level
    Intermediate