Using Formulas to Obtain Data in Google Sheets 2020

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

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Getting to know your data in Google Sheets 2020
    3m 6s
    UP NEXT
  • Playable
    2. 
    Retrieving date information in Google Sheets 2020
    3m 54s
  • Locked
    3. 
    Displaying & retrieving information about your data in Google Sheets 2020
    4m 44s
  • Locked
    4. 
    Finding the largest & smallest values in a list in Google Sheets 2020
    4m
  • Locked
    5. 
    Separating your data in Google Sheets 2020
    4m 11s
  • Locked
    6. 
    Combining data in Google Sheets 2020
    4m 14s
  • Locked
    7. 
    Comparing two lists in Google Sheets 2020
    4m 53s
  • Locked
    8. 
    Inserting data automatically in Google Sheets 2020
    2m 27s
  • Locked
    9. 
    Identifying errors in formulas in Google Sheets 2020
    4m 5s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1630 Likes 1630  
Likes 231 Likes 231  
Likes 123 Likes 123