# Finding & Analyzing Information with Formulas

Excel 2019 (Windows)
• 9 Videos | 36m 41s
• Includes Assessment
• CPE
• PMI PDU
Likes 44
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.

## 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 103
Likes 146
Likes 0

Likes 53
Likes 74
Likes 41