Finding & Analyzing Information with Formulas

Excel 2019 (Windows)
  • 9 Videos | 36m 41s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 44 Likes 44
A wide variety of Excel tools can be used to retrieve, return, and calculate data. In this 9-video course, learners will see how to retrieve date information and rank values, combine and separate data already available, and automate and simplify calculations with look-up tools and SUMPRODUCT. Key concepts covered here include how to extract date values and perform calculations by using dates; how to retrieve information relating to dates in the past, present, and future; and how to use ranking formulas to find smallest and largest values in a list. Next, learn how to extract data and separate values into separate cells; how to combine existing data values in a single cell; and how to analyze complex tables with multiple arrays to obtain summarized results. Continue by observing how to use VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values; how to use conditional formulas to perform a search across multiple tables and automatically insert data; and how to use VLOOKUP formula to cross-reference data lists and retrieve corresponding values.

WHAT YOU WILL LEARN

  • use dates to retrieve information
    find a date automatically
    find the largest and smallest values in a list
    separate data into multiple cells
    combine data values in a single cell
  • create automatic reports
    cross-reference data with formulas
    perform a search across tables
    use formulas to insert data automatically

IN THIS COURSE

  • Playable
    1. 
    Retrieving information with dates
    4m 56s
    UP NEXT
  • Playable
    2. 
    Finding a date automatically
    3m 17s
  • Locked
    3. 
    Finding the largest & smallest values in a list
    4m 1s
  • Locked
    4. 
    Separating data into multiple cells
    6m 23s
  • Locked
    5. 
    Combining data values in a single cell
    3m 22s
  • Locked
    6. 
    Creating automatic reports
    2m 56s
  • Locked
    7. 
    Cross-referencing data with formulas
    3m 16s
  • Locked
    8. 
    Performing a search across two tables
    4m 4s
  • Locked
    9. 
    Inserting data automatically with formulas
    4m 26s

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

Likes 103 Likes 103  
Likes 146 Likes 146  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 53 Likes 53  
Likes 74 Likes 74  
Likes 41 Likes 41