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