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 datesFinding a date automaticallyFinding the largest & smallest values in a listSeparating data into multiple cellsCombining data values in a single cellRetrieving information on a cellRetrieving information on your text
-
Cross referencing two data listsInserting data automaticallyFinding a value in a double entry tablePerforming a search across two tablesFinding data in a databasePerforming 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