Extracting Information with Formulas
Excel 2013 (Windows)
| Intermediate
- 13 Videos | 1h 9m 13s
- Earns a Badge
You can use formulas to extract and analyze data in your spreadsheet. Discover how to use the MAX, MIN, LARGE, and SMALL formulas, and work with VLOOKUP to cross-reference the contents of two lists.
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 dates5m 48sUP NEXT
-
2.Finding a date automatically7m 36s
-
3.Finding the largest & smallest values in a list7m 31s
-
4.Separating data into multiple cells6m 26s
-
5.Combining data values in a single cell2m 29s
-
6.Retrieving information on a cell2m 52s
-
7.Retrieving information on your text2m 55s
-
8.Cross referencing two data lists3m 9s
-
9.Inserting data automatically4m 1s
-
10.Finding a value in a double entry table7m 6s
-
11.Performing a search across two tables5m 20s
-
12.Finding data in a database7m 36s
-
13.Performing calculations using your database6m 25s
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
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

BOOK
Excel 2019 Bible