Extracting Information with Formulas

Excel 2016 (Mac)    |    Intermediate
  • 10 Videos | 43m 24s
  • Earns a Badge
Likes 20 Likes 20
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
    3m 46s
    UP NEXT
  • Playable
    2. 
    Finding a date automatically
    6m 4s
  • Locked
    3. 
    Finding the largest & smallest values in a list
    5m 20s
  • Locked
    4. 
    Separating data into multiple cells
    4m 50s
  • Locked
    5. 
    Combining data values in a single cell
    2m 24s
  • Locked
    6. 
    Inserting data automatically
    4m 20s
  • Locked
    7. 
    Retrieving information on a cell
    3m 28s
  • Locked
    8. 
    Retrieving information on your text
    2m 37s
  • Locked
    9. 
    Finding data in a database
    6m 7s
  • Locked
    10. 
    Performing calculations using your database
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 1 Likes 1  
COURSE Managing Data
Likes 50 Likes 50  
Likes 67 Likes 67  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 21 Likes 21  
Likes 212 Likes 212  
Likes 229 Likes 229