Productivity & Collaboration Tools     Microsoft Office 365     Excel 365

---

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.

---

---

Objectives

Excel 365: Finding and analyzing data with formulas 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 Knowledge Check: Finding and analyzing data with formulas in Excel 365