# Using Formulas to Obtain Data

• 9 Videos | 40m 5s
• Includes Assessment
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

• 1.
• 2.
Retrieving date information
• 3.
• 4.
Finding the largest & smallest values in a list
• 5.
• 6.
Combining data
• 7.
Comparing two lists
• 8.
Inserting data automatically
• 9.
Identifying errors in formulas

## 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.

Likes 1
Likes 44
Likes 103