Using Formulas to Obtain Data

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
    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 Inserting & Managing data
Likes 35 Likes 35  
COURSE Formatting data
Likes 33 Likes 33  
COURSE Customizing text & number formats in Excel 365
Likes 1 Likes 1