Extracting Information with Formulas in Excel 2016 for Mac

Excel 2016 (Mac)    |    Intermediate
  • 10 videos | 43m 24s
  • Earns a Badge
Likes 30 Likes 30
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Retrieving information with dates in Excel 2016 for Mac
    3m 46s
    UP NEXT
  • Playable
    2. 
    Finding a date automatically in Excel 2016 for Mac
    6m 4s
  • Locked
    3. 
    Finding the largest & smallest values in a list in Excel 2016 for Mac
    5m 20s
  • Locked
    4. 
    Separating data into multiple cells in Excel 2016 for Mac
    4m 50s
  • Locked
    5. 
    Combining data values in a single cell in Excel 2016 for Mac
    2m 24s
  • Locked
    6. 
    Inserting data automatically in Excel 2016 for Mac
    4m 20s
  • Locked
    7. 
    Retrieving information on a cell in Excel 2016 for Mac
    3m 28s
  • Locked
    8. 
    Retrieving information on your text in Excel 2016 for Mac
    2m 37s
  • Locked
    9. 
    Finding data in a database in Excel 2016 for Mac
    6m 7s
  • Locked
    10. 
    Performing calculations using your database in Excel 2016 for Mac
    4m 28s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE