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
Rating 4.5 of 449 users Rating 4.5 of 449 users (449)
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

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

  • 47s
    This video outlines the key content covered in the Microsoft 365: Finding and analyzing data with formulas in Excel 365 course, including how to find the minimum, maximum and average values in a cell range, use date functions to find precise information relating to a specific date, and how to cross-reference data with formulas in Excel. FREE ACCESS
  • 3m 7s
    In Excel 365 you can quickly apply formulas to multiple data entries with Fill Down. In this video, you will explore how to use Fill Down to automate formulas in Excel 365. FREE ACCESS
  • Locked
    3.  Finding minimum, maximum & average values
    3m 28s
    Excel 365 has specific formulas you can use depending on which value you'd like to find. You can use MIN and MAX to find the minimum and maximum values. The function AVERAGE is used to find the average value in a range. And if you need to consult which cells have formulas in your sheet, you can quickly display formulas in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 4.2.1 Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions. As well as MOS MO-200 / Excel Associate Certification exam objective: 1.4.6 Display formulas. FREE ACCESS
  • Locked
    4.  Finding the largest or smallest values in a list
    2m 7s
    In Excel 365 you can easily find the fourth largest or second smallest value in a data set, for instance. In this video, you will explore how to find the largest or smallest value in a list in Excel 365. FREE ACCESS
  • Locked
    5.  Retrieving information with dates
    4m 27s
    Excel 365 features date functions that can be used to return precise information relating to a particular month, day, or year. In this video, you will discover how to retrieve information with dates in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.3.2 Calculate dates by using the WEEKDAY() and WORKDAY() functions. FREE ACCESS
  • Locked
    6.  Retrieving a date value automatically
    2m 47s
    In Excel 365 you can automatically find a date based on a fixed date, such as the last date of the previous month. In this video, you will explore how to retrieve a date automatically in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.3.1 Reference date and time by using the NOW() and TODAY() functions. FREE ACCESS
  • Locked
    7.  Inserting data automatically with formulas
    4m 26s
    In Excel 365, you can quickly retrieve data and fill out your data tables. In this video, you will explore how to insert data automatically with formulas in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.2.1 Look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions. FREE ACCESS
  • Locked
    8.  Performing a lookup across two tables
    3m 46s
    In Excel 365, you can search for a value in two separate data tables using the IF and VLOOKUP functions. In this video, you will explore how to perform a lookup across two tables in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.2.1 Look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions. FREE ACCESS
  • Locked
    9.  Finding a value in a double-entry table
    3m 44s
    With Excel 365, you can easily find values located on a separate worksheet. In this video, you will discover how to find a value in a double-entry table in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.2.1 Look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions. FREE ACCESS
  • Locked
    10.  Cross-referencing data with formulas
    4m 11s
    You can easily cross-reference the contents of two lists in Excel 365. In this video, you will explore how to cross-reference data with formulas in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.2.1 Look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions. FREE ACCESS
  • Locked
    11.  Creating automatic reports
    3m 20s
    In Excel 365, you can chain together calculations using multiple data ranges and produce a summary of a data table. In this video, you will learn how to create automatic reports in Excel 365. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.3 of 364 users Rating 4.3 of 364 users (364)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.5 of 319 users Rating 4.5 of 319 users (319)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 416 users Rating 4.6 of 416 users (416)
Rating 4.6 of 378 users Rating 4.6 of 378 users (378)
Rating 4.6 of 385 users Rating 4.6 of 385 users (385)