# Finding & Analyzing Information with Formulas in Excel Microsoft 365 for Windows

Excel Microsoft 365 (Windows)    |    Intermediate
• 9 videos | 41m 30s
• Includes Assessment
Likes 159
Learners can explore the wide variety of tools available in Excel 365 for Office to retrieve, return, and calculate data in Excel, in this 9-video course. First, learn several formulas to automatically find a date for a specific month, day, or year. Then learn how to use Excel's RANK function to find a specific value in a data list, and how to use SMALL and LARGE formulas. This course demonstrates how to use the CONCAT and TEXT JOIN formulas to combine data from multiple cells into a single cell. You will observe how to use SUMPRODUCT formula to link calculations to produce a summary of a data table. Continue by learning how to use the VLOOKUP and HLOOKUP formulas to cross-reference the contents of two lists, and to find data in a table or data range in one list by using a search term from another list. Finally, you will learn how to use the VLOOKUP formula to perform lookup operations with lists and return corresponding values.

## WHAT YOU WILL LEARN

• extract date values and perform calculations using dates retrieve information relating to dates in the past, present, and future use ranking formulas to find smallest and largest values in a list extract data and separate values into separate cells in Excel combine existing data values in a single cell in Excel
• analyze complex tables with multiple arrays to obtain a summarized result use the VLOOKUP, HLOOKUP and XLOOKUP formulas to cross-reference data lists and check for missing values use conditional formulas to perform a search across multiple tables and automatically insert data use the VLOOKUP formula to cross-reference data lists and retrieve corresponding values

## IN THIS COURSE

• Excel features a number of different date formulas that can be used to return precise information relating to a particular month, day or year. There are also formulas for calculating workdays and days elapsed between dates.
• Some formulas in Excel can be used to automatically find a date according to specified criteria. You can, for example, find out the last date of the previous month, the current day and time, and the equivalent date from a previous or future month.
• 3.  Finding the largest & smallest values in a list in Excel Microsoft 365 for Windows
Excel's RANK function is extremely useful if you want to find out where a particular value places in a list of data entries. You can also visualize the smallest and largest values in a list by using the SMALL and LARGE formulas.
• 4.  Separating data into multiple cells in Excel Microsoft 365 for Windows
If you have a large amount of data inserted into your cells, you can use Excel formulas to separate your entries and extract the individual components you need. The SEARCH, LEN, LEFT, RIGHT and MID formulas can all be used to extract the different information and elements you might need.
• 5.  Combining data values in a single cell in Excel Microsoft 365 for Windows
The CONCATENATE formula can be used in Excel to combine in a single cell data taken from multiple cells in your worksheet.
• 6.  Creating automatic reports in Excel Microsoft 365 for Windows
The SUMPRODUCT formula can be used to chain together calculations using multiple data ranges and produce a summary of a data table. This is very useful if you need to use data that has already been added to a workbook and you don't want to break up complex data tables.
• 7.  Cross-referencing data with formulas in Excel Microsoft 365 for Windows
In Excel, you can use the VLOOKUP and HLOOKUP formulas to cross-reference the contents of two lists. This is useful when checking for missing values in your lists. You can also use XLOOKUP for finding data in a table or data range in one list by using a search term from another list.
• 8.  Performing a search across two tables in Excel Microsoft 365 for Windows
In Excel, you can use a calculation combining the IF and VLOOKUP formulas to search for a value in two separate data tables. This is very useful if you want to consult multiple data sources and use them to automatically complete a summary table.
• 9.  Inserting data automatically with formulas in Excel Microsoft 365 for Windows
In Excel, you can use the VLOOKUP formula to perform look-up operations with lists and return corresponding values. This can help you to quickly retrieve data and fill out your data tables.

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