Course details

Google Sheets: Extracting Information with Formulas

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