Using Formulas to Obtain Data

Google Sheets 2020    |    Expert
  • 9 Videos | 40m 5s
  • 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.

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
    3m 6s
    UP NEXT
  • Playable
    2. 
    Retrieving date information
    3m 54s
  • Locked
    3. 
    Displaying & retrieving information about your data
    4m 44s
  • Locked
    4. 
    Finding the largest & smallest values in a list
    4m
  • Locked
    5. 
    Separating your data
    4m 11s
  • Locked
    6. 
    Combining data
    4m 14s
  • Locked
    7. 
    Comparing two lists
    4m 53s
  • Locked
    8. 
    Inserting data automatically
    2m 27s
  • Locked
    9. 
    Identifying errors in formulas
    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

Likes 3 Likes 3  
Likes 10 Likes 10