Extracting Information with Formulas

Excel 2013 (Windows)    |    Intermediate
  • 13 Videos | 1h 9m 13s
  • Earns a Badge
Likes 46 Likes 46
You can use formulas to extract and analyze data in your spreadsheet. Discover how to use the MAX, MIN, LARGE, and SMALL formulas, and work with VLOOKUP to cross-reference the contents of two lists.

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
    5m 48s
    UP NEXT
  • Playable
    2. 
    Finding a date automatically
    7m 36s
  • Locked
    3. 
    Finding the largest & smallest values in a list
    7m 31s
    FREE ACCESS
  • Locked
    4. 
    Separating data into multiple cells
    6m 26s
    FREE ACCESS
  • Locked
    5. 
    Combining data values in a single cell
    2m 29s
    FREE ACCESS
  • Locked
    6. 
    Retrieving information on a cell
    2m 52s
    FREE ACCESS
  • Locked
    7. 
    Retrieving information on your text
    2m 55s
    FREE ACCESS
  • Locked
    8. 
    Cross referencing two data lists
    3m 9s
    FREE ACCESS
  • Locked
    9. 
    Inserting data automatically
    4m 1s
    FREE ACCESS
  • Locked
    10. 
    Finding a value in a double entry table
    7m 6s
    FREE ACCESS
  • Locked
    11. 
    Performing a search across two tables
    5m 20s
    FREE ACCESS
  • Locked
    12. 
    Finding data in a database
    7m 36s
    FREE ACCESS
  • Locked
    13. 
    Performing calculations using your database
    6m 25s
    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 Manipulating PivotTable data in Excel 365
BOOK Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

BOOK Advance Excel 2016 Training Guide
COURSE PivotTables & PivotCharts
Likes 40 Likes 40  
BOOK Excel 2019 Bible