### 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