Excel 2019: Finding & Analyzing Information with Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

A wide variety of Excel tools can be used to retrieve, return, and calculate data. In this 9-video course, learners will see how to retrieve date information and rank values, combine and separate data already available, and automate and simplify calculations with look-up tools and SUMPRODUCT. Key concepts covered here include how to extract date values and perform calculations by using dates; how to retrieve information relating to dates in the past, present, and future; and how to use ranking formulas to find smallest and largest values in a list. Next, learn how to extract data and separate values into separate cells; how to combine existing data values in a single cell; and how to analyze complex tables with multiple arrays to obtain summarized results. Continue by observing how to use VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values; how to use conditional formulas to perform a search across multiple tables and automatically insert data; and how to use VLOOKUP formula to cross-reference data lists and retrieve corresponding values.



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