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
    FREE ACCESS
  • Locked
    4. 
    Finding the largest & smallest values in a list
    4m
    FREE ACCESS
  • Locked
    5. 
    Separating your data
    4m 11s
    FREE ACCESS
  • Locked
    6. 
    Combining data
    4m 14s
    FREE ACCESS
  • Locked
    7. 
    Comparing two lists
    4m 53s
    FREE ACCESS
  • Locked
    8. 
    Inserting data automatically
    2m 27s
    FREE ACCESS
  • Locked
    9. 
    Identifying errors in formulas
    4m 5s
    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 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

COURSE Enhancing your documents
Likes 3 Likes 3  
COURSE Using conditional formulas in Excel 365
COURSE Using Basic Formulas
Likes 10 Likes 10