# Finding & Analyzing Information with Formulas

Excel Microsoft 365 (Windows)
• 9 Videos | 46m
• Includes Assessment
Likes 103
Learners can explore the wide variety of tools available in Excel 365 for Office to retrieve, return, and calculate data in Excel, in this 9-video course. First, learn several formulas to automatically find a date for a specific month, day, or year. Then learn how to use Excel's RANK function to find a specific value in a data list, and how to use SMALL and LARGE formulas. This course demonstrates how to use the CONCAT and TEXT JOIN formulas to combine data from multiple cells into a single cell. You will observe how to use SUMPRODUCT formula to link calculations to produce a summary of a data table. Continue by learning how to use the VLOOKUP and HLOOKUP formulas to cross-reference the contents of two lists, and to find data in a table or data range in one list by using a search term from another list. Finally, you will learn how to use the VLOOKUP formula to perform lookup operations with lists and return corresponding values.

## WHAT YOU WILL LEARN

• 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, HLOOKUP and XLOOKUP 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

## IN THIS COURSE

• 1.
Retrieving information with dates
• 2.
Finding a date automatically
• 3.
Finding the largest & smallest values in a list
• 4.
Separating data into multiple cells
• 5.
Combining data values in a single cell
• 6.
Creating automatic reports
• 7.
Cross-referencing data with formulas
• 8.
Performing a search across two tables
• 9.
Inserting data automatically with formulas

## EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

## YOU MIGHT ALSO LIKE

COURSE Managing Data
Likes 25
Likes 206
Likes 120

Likes 705
Likes 89
Likes 206