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