Google Sheets: Referencing Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

A reference tells Google Sheets which cell or cells contain the needed values. Discover absolute, relative, and indirect cell references; how to use data from several sheets; and how to create data ranges and constant values.



Expected Duration (hours)
0.6

Lesson Objectives

Google Sheets: Referencing Data

  • Referencing cells
  • Choosing between absolute & relative cell references
  • Defining a new data range
  • Using data from several sheets
  • Calculating with constant values
  • Using cell references indirectly

    • Course Number:
    ds_gshee16_07_enus

    Expertise Level
    Beginner