Google Sheets: Extracting Information with Formulas 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 data and text values, and how to use LOOKUP and VLOOKUP.
Expected Duration (hours)
1.1
Lesson Objectives Google Sheets: Extracting Information with Formulas
Getting to know your data
Retrieving date information
Displaying information on your data
Retrieving information on your text
Finding the largest & smallest values in a list
Separating your data
Combining data
Comparing two lists
Inserting data automatically
Finding data in a database
Performing calculations using your database
Finding a value in a double entry table
Performing a search across two tables
Identifying errors in formulas
Customizing the formula options in your spreadsheet
Course Number: ds_gshee16_13_12_enus
Expertise Level
Intermediate