Course details

Excel 2019: Finding & Analyzing Information with Formulas

Excel 2019: Finding & Analyzing Information with Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

There is a wide variety of tools that can be used to retrieve, return, and calculate data in Excel. See how to retrieve date information and rank values, retrieve, combine and separate data that is already available, and automate and simplify calculations using look-up tools and SUMPRODUCT.



Expected Duration (hours)
0.6

Lesson Objectives

Excel 2019: Finding & Analyzing Information with Formulas

  • extract date values and perform calculations using dates
  • retrieve information relating to dates in the past, present, and future
  • use ranking formulas to find smallest and largest values in a list
  • extract data and separate values into separate cells in Excel
  • combine existing data values in a single cell in Excel
  • analyze complex tables with multiple arrays to obtain a summarized result
  • use the VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values
  • use conditional formulas to perform a search across multiple tables and automatically insert data
  • use the VLOOKUP formula to cross-reference data lists and retrieve corresponding values
  • Course Number:
    ds_msex2019_19_enus

    Expertise Level
    Intermediate