Excel 2010: Extracting Information with Formulas
Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
Excel 2010 is a highly customizable application. Discover how to extract information with formulas, cross reference data lists, insert data automatically, and more.
Expected Duration (hours)
1.0
Lesson Objectives Excel 2010: 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 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_msex2010_14_enus
Expertise Level
Intermediate