Using Formulas to Obtain Data
Google Sheets 2020
| Expert
- 9 Videos | 35m 35s
- 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 formulasuse formulas to find information about datesuse formulas to display and retrieve information about data entriesfind the largest and smallest valuesseparate data into different cells
-
combinate data from different cellscompare two lists with the VLOOKUP functionuse the HLOOKUP function to insert dataidentify and highlight errors in formulas
IN THIS COURSE
-
1.Getting to know your data3m 6sUP NEXT
-
2.Retrieving date information3m 54s
-
3.Displaying & retrieving information about your data4m 44s
-
4.Finding the largest & smallest values in a list4m
-
5.Separating your data4m 11s
-
6.Combining data4m 14s
-
7.Comparing two lists4m 53s
-
8.Inserting data automatically2m 27s
-
9.Identifying errors in formulas4m 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.