Microsoft Excel 2016 for Mac: Extracting Information with Formulas Overview/Description Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description 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.
Expected Duration (hours)
0.7
Lesson 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
Course Number: ds_msex16mc_13_enus
Expertise Level
Intermediate