Finding and analyzing data with formulas in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 Videos | 48m 1s
  • 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
    58s
    UP NEXT
  • Playable
    2. 
    Using Fill Down to automate formulas
    4m 7s
  • Locked
    3. 
    Finding minimum, maximum & average values
    4m 35s
  • Locked
    4. 
    Finding the largest or smallest values in a list
    2m 48s
  • Locked
    5. 
    Retrieving information with dates
    5m 59s
  • Locked
    6. 
    Retrieving a date value automatically
    3m 43s
  • Locked
    7. 
    Inserting data automatically with formulas
    5m 46s
  • Locked
    8. 
    Performing a lookup across two tables
    5m 3s
  • Locked
    9. 
    Finding a value in a double-entry table
    5m 1s
  • Locked
    10. 
    Cross-referencing data with formulas
    5m 35s
  • Locked
    11. 
    Creating automatic reports
    4m 28s

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 129 Likes 129  
Likes 0 Likes 0  
Likes 1 Likes 1