Extracting Information with Formulas in Excel 2016 for Windows
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 dates in Excel 2016 for Windows4m 44sUP NEXT
-
2.Finding a date automatically in Excel 2016 for Windows3m 22s
-
3.Finding the largest & smallest values in a list in Excel 2016 for Windows6m 30s
-
4.Separating data into multiple cells in Excel 2016 for Windows4m 32s
-
5.Combining data values in a single cell in Excel 2016 for Windows2m 36s
-
6.Retrieving information on a cell in Excel 2016 for Windows3m 23s
-
7.Retrieving information on your text in Excel 2016 for Windows2m 38s
-
8.Cross referencing two data lists in Excel 2016 for Windows2m 29s
-
9.Inserting data automatically in Excel 2016 for Windows3m 10s
-
10.Finding a value in a double entry table in Excel 2016 for Windows4m 10s
-
11.Performing a search across two tables in Excel 2016 for Windows2m 51s
-
12.Finding data in a database in Excel 2016 for Windows6m 2s
-
13.Performing calculations using your database in Excel 2016 for Windows3m 29s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.