SkillSoft Explore Course – Lambers, Inc.

BUY NOW! STARTING AT ONLY $299!

Productivity & Collaboration Tools Microsoft Office for Mac 2016 Microsoft Office for Mac 2016: Excel (No Assessments)

Excel includes a number of formulas for extracting information from data. DiscoverÂ how to use a number of these formulas, including MAX, MIN, LARGE, SMALL, CONCAT, andÂ VLOOKUP.

Asset ID	ds_msex16mc_13_enus
Course Type	Video Course
Course Category	Microsoft Office for Mac 2016

Objectives
Microsoft Excel 2016 for Mac: Extracting Information with Formulas retrieve information with dates find dates automatically using formulas find the smallest and largest values in a list separate data into multiple cells combine data values in a single cell insert data automatically into Excel 2016 for Ma retrieve information using the CELL formula retrieve information from your text-based data find data in a database in Excel 2016 for Mac perform calculations using your data

Objectives

Microsoft Excel 2016 for Mac: Extracting Information with Formulas

retrieve information with dates
find dates automatically using formulas
find the smallest and largest values in a list
separate data into multiple cells
combine data values in a single cell
insert data automatically into Excel 2016 for Ma
retrieve information using the CELL formula
retrieve information from your text-based data
find data in a database in Excel 2016 for Mac
perform calculations using your data