Extracting Information with Formulas

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
    3m 46s
    UP NEXT
  • Playable
    2. 
    Finding a date automatically
    6m 4s
  • Locked
    3. 
    Finding the largest & smallest values in a list
    5m 20s
    FREE ACCESS
  • Locked
    4. 
    Separating data into multiple cells
    4m 50s
    FREE ACCESS
  • Locked
    5. 
    Combining data values in a single cell
    2m 24s
    FREE ACCESS
  • Locked
    6. 
    Inserting data automatically
    4m 20s
    FREE ACCESS
  • Locked
    7. 
    Retrieving information on a cell
    3m 28s
    FREE ACCESS
  • Locked
    8. 
    Retrieving information on your text
    2m 37s
    FREE ACCESS
  • Locked
    9. 
    Finding data in a database
    6m 7s
    FREE ACCESS
  • Locked
    10. 
    Performing calculations using your database
    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 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

COURSE Finding and analyzing data with formulas in Excel 365
COURSE Working with Macros in Excel
Likes 67 Likes 67  
COURSE Basic Formulas
Likes 40 Likes 40  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

BOOK Excel 2019 Bible
COURSE Using Basic Formulas
Likes 266 Likes 266  
BOOK VLOOKUP Awesome Quick: From Your First Excel VLOOKUP to Becoming a VLOOKUP Guru