Excel 365 – Find and analyze information using formulas

Overview

Students can explore a wide range of tools available in Excel 365 for Office to extract, return, and calculate data in Excel in this 9-clip course. First, you’ll learn several formulas to automatically find a date for certain months, days, or years. Then you will learn how to use the RANK function in Excel to find a certain value in a data list and how to use the SMALL and LARGE formulas. This course demonstrates how to use the CONCAT and TEXTJOIN formulas to combine data from multiple cells into a single cell. You’ll notice how to use the SUMPRODUCT formula to connect calculations to produce a summary of a data table. Continue to learn how to use the VLOOKUP and HLOOKUP formulas to compare the contents of two lists and find data from a table or data range in a single list, using a search term from another list. Finally, you will learn how to use the VLOOKUP formula to perform list search operations and return the corresponding values.

Objectives

• Extracting data values and performing calculations using data
• Extracting information from past, present, and future data
• Using the RANK formula to find the smallest and largest values in a list
• Extracting data and separating values into cells separate in Excel
• combining existing data values in a single cell in Excel
• analyzing complex tables through multiple matrices to get a cumulative result
• using VLOOKUP, HLOOKUP and XLOOKUP formulas to compare lists of data and check for missing values
• use conditional formulas to search multiple tables and insert data automatically
• use VLOOKUP formula to compare data lists and extract corresponding values