Extracting Information with Formulas

Excel 2010 (Windows)    |    Intermediate
  • 13 Videos | 1h 1m 45s
  • Earns a Badge
Likes 26 Likes 26
Excel 2010 is a highly customizable application. Discover how to extract information with formulas, cross reference data lists, insert data automatically, and more.

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 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
    3m 57s
    UP NEXT
  • Playable
    2. 
    Finding a date automatically
    6m 9s
  • Locked
    3. 
    Finding the largest & smallest values in a list
    5m 46s
  • Locked
    4. 
    Separating data into multiple cells
    5m 45s
  • Locked
    5. 
    Combining data in a single cell
    2m 32s
  • Locked
    6. 
    Retrieving information on a cell
    4m 25s
  • Locked
    7. 
    Retrieving information on your text
    2m 43s
  • Locked
    8. 
    Cross referencing two data lists
    3m 21s
  • Locked
    9. 
    Inserting data automatically
    3m 26s
  • Locked
    10. 
    Finding a value in a double entry table
    5m 56s
  • Locked
    11. 
    Performing a search across two tables
    4m 50s
  • Locked
    12. 
    Finding data in a database
    6m
  • Locked
    13. 
    Performing calculations using your database
    5m 56s

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

CHANNEL Excel
Likes 2186 Likes 2186  
Likes 61 Likes 61  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 139 Likes 139  
Likes 775 Likes 775  
Likes 279 Likes 279