Using Formulas to Obtain Data in Google Sheets 2020

Google Sheets 2020    |    Expert
  • 9 videos | 35m 35s
  • Includes Assessment
  • Earns a Badge
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.


  • 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


  • 3m 6s
    Use different functions in Google Sheets to display information relating to your data. For example, ask Google Sheets to tell you whether a certain data entry is a number, what sort of number it is, and even if it is referenced in another cell. This video will introduce you to the functions ISEVEN, ISNUMBER and ISREF. FREE ACCESS
  • 3m 54s
    Google Sheets features functions that can be used to extract information relating specifically to dates. This video will introduce you to the DAY, MONTH and WEEKDAY functions. You will also learn how to find information about two different dates. FREE ACCESS
  • Locked
    3.  Displaying & retrieving information about your data in Google Sheets 2020
    4m 44s
    If you need information relating to your cell's relationship to its spreadsheet, use the ROW and COLUMN functions. In Google Sheets you can also use the functions LEN and SEARCH to get information relating to the contents of your spreadsheet's cells. FREE ACCESS
  • Locked
    4.  Finding the largest & smallest values in a list in Google Sheets 2020
    If you have a large number of data entries in your spreadsheet, you may find it useful to be able to quickly analyze their position in your table. This video will show you how to locate the smallest and largest values in your table with Google Sheets. FREE ACCESS
  • Locked
    5.  Separating your data in Google Sheets 2020
    4m 11s
    If you have a cell containing a large amount of data and you want to extract its various different components into separate cells, you can use the LEFT and RIGHT functions in Google Sheets. In this video, you will find out how to break up your cell's data in order to insert it elsewhere. You will also see how to split text elements between columns using commas, semicolons, spaces or other custom separators. FREE ACCESS
  • Locked
    6.  Combining data in Google Sheets 2020
    4m 14s
    In Google Sheets, you can take data found in a number of different cells and combine it in one, single cell. This video will show you how to do so using the CONCATENATE function. FREE ACCESS
  • Locked
    7.  Comparing two lists in Google Sheets 2020
    4m 53s
    If you need to compare two lists of data in Google Sheets, the VLOOKUP function can prove very useful. This video will show you how to build a formula to analyze two lists and return the data that you are looking for. FREE ACCESS
  • Locked
    8.  Inserting data automatically in Google Sheets 2020
    2m 27s
    In Google Sheets, you can use the HLOOKUP formula to automatically insert data into your spreadsheet. To do this, you simply need to create an additional data table which can then be referenced. FREE ACCESS
  • Locked
    9.  Identifying errors in formulas in Google Sheets 2020
    4m 5s
    When inserting formulas into your spreadsheet, you may sometimes find that an error occurs. The formula IFERROR allows you to specify what message is returned if there is an error in your formula, allowing you to very quickly identify where problems have occurred. FREE ACCESS


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.