Extracting Information with Formulas
Excel 2013 (Windows)
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 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 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.
