Finding and analyzing data with formulas in Excel 365
Excel Microsoft 365 (2021)
| Intermediate
- 11 videos | 36m 11s
- Includes Assessment
- Earns a Badge
- 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 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
-
47sThis 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 7sIn 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
-
3. Finding minimum, maximum & average values3m 28sExcel 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
-
4. Finding the largest or smallest values in a list2m 7sIn 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
-
5. Retrieving information with dates4m 27sExcel 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
-
6. Retrieving a date value automatically2m 47sIn 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
-
7. Inserting data automatically with formulas4m 26sIn 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
-
8. Performing a lookup across two tables3m 46sIn 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
-
9. Finding a value in a double-entry table3m 44sWith 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
-
10. Cross-referencing data with formulas4m 11sYou 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
-
11. Creating automatic reports3m 20sIn 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.
