Finding & Analyzing Information with Formulas

Excel Microsoft 365 (Windows)    |    Intermediate
  • 9 Videos | 41m 30s
  • Includes Assessment
  • Earns a Badge
Likes 159 Likes 159
Learners can explore the wide variety of tools available in Excel 365 for Office to retrieve, return, and calculate data in Excel, in this 9-video course. First, learn several formulas to automatically find a date for a specific month, day, or year. Then learn how to use Excel's RANK function to find a specific value in a data list, and how to use SMALL and LARGE formulas. This course demonstrates how to use the CONCAT and TEXT JOIN formulas to combine data from multiple cells into a single cell. You will observe how to use SUMPRODUCT formula to link calculations to produce a summary of a data table. Continue by learning how to use the VLOOKUP and HLOOKUP formulas to cross-reference the contents of two lists, and to find data in a table or data range in one list by using a search term from another list. Finally, you will learn how to use the VLOOKUP formula to perform lookup operations with lists and return corresponding values.

WHAT YOU WILL LEARN

  • extract date values and perform calculations using dates
    retrieve information relating to dates in the past, present, and future
    use ranking formulas to find smallest and largest values in a list
    extract data and separate values into separate cells in Excel
    combine existing data values in a single cell in Excel
  • analyze complex tables with multiple arrays to obtain a summarized result
    use the VLOOKUP, HLOOKUP and XLOOKUP formulas to cross-reference data lists and check for missing values
    use conditional formulas to perform a search across multiple tables and automatically insert data
    use the VLOOKUP formula to cross-reference data lists and retrieve corresponding values

IN THIS COURSE

  • Playable
    1. 
    Retrieving information with dates
    5m 17s
    UP NEXT
  • Playable
    2. 
    Finding a date automatically
    3m 47s
  • Locked
    3. 
    Finding the largest & smallest values in a list
    4m 10s
    FREE ACCESS
  • Locked
    4. 
    Separating data into multiple cells
    6m 22s
    FREE ACCESS
  • Locked
    5. 
    Combining data values in a single cell
    3m 32s
    FREE ACCESS
  • Locked
    6. 
    Creating automatic reports
    3m 11s
    FREE ACCESS
  • Locked
    7. 
    Cross-referencing data with formulas
    6m 21s
    FREE ACCESS
  • Locked
    8. 
    Performing a search across two tables
    4m 14s
    FREE ACCESS
  • Locked
    9. 
    Inserting data automatically with formulas
    4m 34s
    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 Creating advanced charts in Excel 365
COURSE Working with tables in Excel 365
Likes 11 Likes 11  
COURSE Using conditional formulas in Excel 365

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Getting to Know Macros in Excel
Likes 210 Likes 210  
COURSE Inserting PivotTables
Likes 238 Likes 238  
COURSE Working with Data in PivotTables
Likes 139 Likes 139