Extracting Information with Formulas in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 13 videos | 49m 56s
  • Includes Assessment
  • Earns a Badge
Likes 102 Likes 102
Excel 2016 has a number of formulas for extracting both numeric and textual data from cells. Discover how to use some of these formulas, including MONTH, DAY, YEAR, MAX, MIN, CONCATENATE, SEARCH, LEN, LOOKUP, and VLOOKUP.

WHAT YOU WILL LEARN

  • 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
    Retrieving information on a cell
    Retrieving information on your text
  • Cross referencing two data lists
    Inserting data automatically
    Finding a value in a double entry table
    Performing a search across two tables
    Finding data in a database
    Performing calculations using your database

IN THIS COURSE

  • Playable
    1. 
    Retrieving information with dates in Excel 2016 for Windows
    4m 44s
    UP NEXT
  • Playable
    2. 
    Finding a date automatically in Excel 2016 for Windows
    3m 22s
  • Locked
    3. 
    Finding the largest & smallest values in a list in Excel 2016 for Windows
    6m 30s
    FREE ACCESS
  • Locked
    4. 
    Separating data into multiple cells in Excel 2016 for Windows
    4m 32s
    FREE ACCESS
  • Locked
    5. 
    Combining data values in a single cell in Excel 2016 for Windows
    2m 36s
    FREE ACCESS
  • Locked
    6. 
    Retrieving information on a cell in Excel 2016 for Windows
    3m 23s
    FREE ACCESS
  • Locked
    7. 
    Retrieving information on your text in Excel 2016 for Windows
    2m 38s
    FREE ACCESS
  • Locked
    8. 
    Cross referencing two data lists in Excel 2016 for Windows
    2m 29s
    FREE ACCESS
  • Locked
    9. 
    Inserting data automatically in Excel 2016 for Windows
    3m 10s
    FREE ACCESS
  • Locked
    10. 
    Finding a value in a double entry table in Excel 2016 for Windows
    4m 10s
    FREE ACCESS
  • Locked
    11. 
    Performing a search across two tables in Excel 2016 for Windows
    2m 51s
    FREE ACCESS
  • Locked
    12. 
    Finding data in a database in Excel 2016 for Windows
    6m 2s
    FREE ACCESS
  • Locked
    13. 
    Performing calculations using your database in Excel 2016 for Windows
    3m 29s
    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
Book Microsoft Excel Professional 2021 Guide: A Complete Excel Reference, Loads of Formulas and Functions, Shortcuts, and Numerous Screenshots to Become an Excel Expert
Course Using data in Sheets 2022

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting Started in Excel 2019 for Windows
Likes 561 Likes 561  
Course Basic Formulas in Excel 2016 for Windows
Likes 335 Likes 335  
Course Finding & Analyzing Information with Formulas in Excel 2019 for Windows
Likes 122 Likes 122