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

  • 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
  • Inserting data automatically
  • Retrieving information on a cell
  • Retrieving information on your text
  • Finding data in a database
  • Performing calculations using your database
  • Course Number:
    ds_msex16mc_13_enus

    Expertise Level
    Intermediate