# Finding & Analyzing Information with Formulas

Excel 2019 (Windows)    |    Intermediate
• 9 Videos | 36m 41s
• Includes Assessment
• CPE
Likes 122
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. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Finding & Analyzing Information with Formulas Exercise as well as the associated materials in the Resources section.

## WHAT YOU WILL LEARN

• use dates to retrieve information
find a date automatically
find the largest and smallest values in a list
separate data into multiple cells
combine data values in a single cell
• create automatic reports
cross-reference data with formulas
perform a search across tables
use formulas to insert data automatically

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

Likes 6
Likes 123

Likes 351
Likes 123
Likes 119