SkillSoft Explore Course – Lambers, Inc.

Desktop Certifications Isograd TOSA Desktop TOSA Excel 2016

Excel 2016 has a number of formulas for extracting both numeric and textual data from cells. Discover how to use some of these formulas, including MONTH, DAY, YEAR, MAX, MIN, CONCATENATE, SEARCH, LEN, LOOKUP, and VLOOKUP.

Asset ID	ds_msex2016_16_enus
Course Type	Video Course
Course Category	Isograd

Objectives
Excel 2016: Extracting Information with Formulas Retrieving information with dates Finding a date automatically Finding the largest & smallest values in a list Separating data into multiple cells Combining data values in a single cell Retrieving information on a cell Retrieving information on your text Cross referencing two data lists Inserting data automatically Finding a value in a double entry table Performing a search across two tables Finding data in a database Performing calculations using your database

Objectives

Excel 2016: Extracting Information with Formulas

Retrieving information with dates
Finding a date automatically
Finding the largest & smallest values in a list
Separating data into multiple cells
Combining data values in a single cell
Retrieving information on a cell
Retrieving information on your text
Cross referencing two data lists
Inserting data automatically
Finding a value in a double entry table
Performing a search across two tables
Finding data in a database
Performing calculations using your database