SkillSoft Explore Course – Lambers, Inc.

Collections Accelerator 2.0: Office 365 Microsoft Microsoft 365: Intermediate Excel

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.

Asset ID	ds_msex365_19_enus
Course Type	Video Course
Course Category	Accelerator 2.0: Office 365

Objectives
Excel Office 365 (Windows): Finding & Analyzing Information with Formulas 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

Objectives

Excel Office 365 (Windows): Finding & Analyzing Information with Formulas

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