Finding and analyzing data with formulas in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 Videos | 36m 11s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
A wide variety of Excel 365 tools can be used to retrieve, return, and calculate data. In this course, you will explore how to use formulas to retrieve specific types of information as well as how to automate and simplify calculations with lookup tools. Key concepts covered include how to automate formulas using the Fill Down tool, how to use formulas to extract date values, and perform calculations by using dates. Next, you will learn how to use VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values; how to find a value in a double-entry table; and how to create automatic reports summarizing a data table with the SUMPRODUCT formula.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Microsoft 365: Finding and analyzing data with formulas in Excel 365 course
    use Fill Down to automate formulas in Excel 365
    find the minimum, maximum and average value in a list
    find the largest or smallest value in a list in Excel 365
    retrieve information with dates in Excel 365
    retrieve a date automatically in Excel 365
  • insert data automatically with formulas in Excel 365
    perform a lookup across two tables in Excel 365
    find a value in a double-entry table in Excel 365
    cross-reference data with formulas in Excel 365
    create automatic reports in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Course Overview: Finding and analyzing data with formulas in Excel 365
    47s
    UP NEXT
  • Playable
    2. 
    Using Fill Down to automate formulas
    3m 7s
  • Locked
    3. 
    Finding minimum, maximum & average values
    3m 28s
  • Locked
    4. 
    Finding the largest or smallest values in a list
    2m 7s
  • Locked
    5. 
    Retrieving information with dates
    4m 27s
  • Locked
    6. 
    Retrieving a date value automatically
    2m 47s
  • Locked
    7. 
    Inserting data automatically with formulas
    4m 26s
  • Locked
    8. 
    Performing a lookup across two tables
    3m 46s
  • Locked
    9. 
    Finding a value in a double-entry table
    3m 44s
  • Locked
    10. 
    Cross-referencing data with formulas
    4m 11s
  • Locked
    11. 
    Creating automatic reports
    3m 20s

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.