Extracting Information with Formulas
Excel 2016 (Windows)
| Intermediate
- 13 Videos | 49m 56s
- Includes Assessment
- Earns a Badge
Excel 2016 has a number of formulas for extracting both numeric and textual data from cells. Discover how to use some of these formulas, including MONTH, DAY, YEAR, MAX, MIN, CONCATENATE, SEARCH, LEN, LOOKUP, and VLOOKUP.
WHAT YOU WILL LEARN
-
Retrieving information with dates
Finding a date automatically
Finding the largest & smallest values in a list
Separating data into multiple cells
Combining data values in a single cell
Retrieving information on a cell
Retrieving information on your text -
Cross referencing two data lists
Inserting data automatically
Finding a value in a double entry table
Performing a search across two tables
Finding data in a database
Performing calculations using your database
IN THIS COURSE
-
1.Retrieving information with dates4m 44sUP NEXT
-
2.Finding a date automatically3m 22s
-
3.Finding the largest & smallest values in a list6m 30s
-
4.Separating data into multiple cells4m 32s
-
5.Combining data values in a single cell2m 36s
-
6.Retrieving information on a cell3m 23s
-
7.Retrieving information on your text2m 38s
-
8.Cross referencing two data lists2m 29s
-
9.Inserting data automatically3m 10s
-
10.Finding a value in a double entry table4m 10s
-
11.Performing a search across two tables2m 51s
-
12.Finding data in a database6m 2s
-
13.Performing calculations using your database3m 29s
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
Using macros in Excel 365
