Using formulas to get data in Sheets 2022

Google Sheets 2022    |    Intermediate
  • 10 videos | 40m 13s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 11 users Rating 4.7 of 11 users (11)
Google Sheets includes built-in formulas to extract and analyze data. First, you will get to know your data by identifying data entries with formulas. Then you will discover how to work with some of these formulas on both numeric and text values. For example, you will learn how to retrieve date information as well as display and retrieve information about your data entries. You are also able to find the largest and smallest values in a list, as well as separate your data. Alternatively, you can combine data and compare two lists by using the VLOOKUP function. You can also use the HLOOKUP function to insert data. Lastly, you can identify errors in formulas by using the IFERROR function.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in the using formulas to get data in sheets 2022 course
    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
    Combine data from different cells
    Compare two lists with the vlookup function
    Use the hlookup function to insert data
    Identify and highlight errors in formulas

IN THIS COURSE

  • 57s
    This video outlines the key content covered in the Using formulas to get data in Sheets 2022 course including retrieving date information, separating your data, and identifying errors in formulas. FREE ACCESS
  • 3m 51s
    You can 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. FREE ACCESS
  • Locked
    3.  Retrieving date information in Sheets 2022
    4m 25s
    Google Sheets features functions that can be used to extract information relating specifically to dates. You can use the DAY, MONTH and WEEKDAY functions. You are also able to find information about two different dates. FREE ACCESS
  • Locked
    4.  Displaying & retrieving information about your data in Sheets 2022
    4m 57s
    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
    5.  Finding the largest & smallest values in a list in Sheets 2022
    4m 38s
    If you have numerous data entries in your spreadsheet, you may find it useful to be able to quickly analyze their position in your table. It is possible to locate the smallest and largest values in your table with Google Sheets. FREE ACCESS
  • Locked
    6.  Separating your data in Sheets 2022
    4m 59s
    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. You are able to break up your cell's data in order to insert it elsewhere. It is also possible to split text elements between columns using commas, semicolons, spaces or other custom separators. FREE ACCESS
  • Locked
    7.  Combining data in Sheets 2022
    4m 1s
    In Google Sheets, it is possible to take data found in a number of different cells and combine it in one, single cell. You can do so using the CONCATENATE and LOWER functions. FREE ACCESS
  • Locked
    8.  Comparing two lists in Sheets 2022
    4m 50s
    If you need to compare two lists of data in Google Sheets, the VLOOKUP function can prove very useful. You are able to build a formula to analyze two lists and return the data that you are looking for. FREE ACCESS
  • Locked
    9.  Inserting data automatically in Sheets 2022
    3m 21s
    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
    10.  Identifying errors in formulas in Sheets 2022
    4m 13s
    When inserting formulas into your spreadsheet, you may sometimes find that an error occurs. The IFERROR function 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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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.

YOU MIGHT ALSO LIKE

Course Getting started in Google Sheets 2022
Rating 4.4 of 161 users Rating 4.4 of 161 users (161)
Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course Enhancing documents in Google Sheets 2022
Rating 4.8 of 19 users Rating 4.8 of 19 users (19)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Creating PivotTables and PivotCharts in Excel 365
Rating 4.4 of 438 users Rating 4.4 of 438 users (438)
Course Data Analysis and Root Cause Analysis in Six Sigma
Rating 4.1 of 1331 users Rating 4.1 of 1331 users (1331)
Course Finding & filtering data in Google Sheets 2022
Rating 4.5 of 24 users Rating 4.5 of 24 users (24)