Excel 2013: Extracting Information with Formulas
Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
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.
Expected Duration (hours)
1.1
Lesson Objectives Excel 2013: Extracting Information with Formulas
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
Course Number: ds_msex2013_17_enus
Expertise Level
Intermediate