Google Sheets: Using Formulas to Obtain Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Google Sheets includes built-in formulas to extract and analyze data. Discover how to work with some of these formulas on both numeric and text values, and how to use LOOKUP and VLOOKUP.

Expected Duration (hours)
0.6

Lesson Objectives

Google Sheets: Using Formulas to Obtain Data

  • identify data entries with formulas
  • use formulas to find information about dates
  • use formulas to display and retrieve information about data entries
  • find the largest and smallest values
  • separate data into different cells
  • combinate data from different cells
  • compare two lists with the VLOOKUP function
  • use the HLOOKUP function to insert data
  • identify and highlight errors in formulas
  • Course Number:
    ds_gshee20_14_enus

    Expertise Level
    Expert