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