Using Formulas to Obtain Data in Google Sheets 2020 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 Using Formulas to Obtain Data in Google Sheets 2020
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