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
    FREE ACCESS
  • Locked
    4. 
    Separating data into multiple cells in Excel 2016 for Mac
    4m 50s
    FREE ACCESS
  • Locked
    5. 
    Combining data values in a single cell in Excel 2016 for Mac
    2m 24s
    FREE ACCESS
  • Locked
    6. 
    Inserting data automatically in Excel 2016 for Mac
    4m 20s
    FREE ACCESS
  • Locked
    7. 
    Retrieving information on a cell in Excel 2016 for Mac
    3m 28s
    FREE ACCESS
  • Locked
    8. 
    Retrieving information on your text in Excel 2016 for Mac
    2m 37s
    FREE ACCESS
  • Locked
    9. 
    Finding data in a database in Excel 2016 for Mac
    6m 7s
    FREE ACCESS
  • Locked
    10. 
    Performing calculations using your database in Excel 2016 for Mac
    4m 28s
    FREE ACCESS

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.

YOU MIGHT ALSO LIKE

Course Referencing data in Excel 365
Course Finding and analyzing data with formulas in Excel 365
Course Managing Data in Excel 2019 for Windows
Likes 50 Likes 50  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Finding & Analyzing Information with Formulas in Excel Microsoft 365 for Windows
Likes 159 Likes 159  
Course Working with Formulas in Excel 2010 for Windows
Likes 21 Likes 21  
Course Referencing Data in Excel 2019 for Windows
Likes 123 Likes 123