# Finding and analyzing data with formulas in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
• 11 videos | 36m 11s
• Includes Assessment
• CPE
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 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

• 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.
• 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.
• 3.  Finding minimum, maximum & average values
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.
• 4.  Finding the largest or smallest values in a list
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.
• 5.  Retrieving information with dates
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.
• 6.  Retrieving a date value automatically
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.
• 7.  Inserting data automatically with formulas
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.
• 8.  Performing a lookup across two tables
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.
• 9.  Finding a value in a double-entry table
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.
• 10.  Cross-referencing data with formulas
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.
• 11.  Creating automatic reports
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.

## 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.