Finding & Analyzing Information with Formulas
Excel Microsoft 365 (Windows)
| Intermediate
- 9 Videos | 46m
- Includes Assessment
- Earns a Badge
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
-
1.Retrieving information with dates5m 17sUP NEXT
-
2.Finding a date automatically3m 47s
-
3.Finding the largest & smallest values in a list4m 10s
-
4.Separating data into multiple cells6m 22s
-
5.Combining data values in a single cell3m 32s
-
6.Creating automatic reports3m 11s
-
7.Cross-referencing data with formulas6m 21s
-
8.Performing a search across two tables4m 14s
-
9.Inserting data automatically with formulas4m 34s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.
