Finding & Analyzing Information with Formulas in Excel 2019 for Windows
Excel 2019 (Windows)
| Intermediate
- 9 videos | 36m 41s
- Includes Assessment
- Earns a Badge
- CPE
A wide variety of Excel tools can be used to retrieve, return, and calculate data. In this 9-video course, learners will see how to retrieve date information and rank values, combine and separate data already available, and automate and simplify calculations with look-up tools and SUMPRODUCT. Key concepts covered here include how to extract date values and perform calculations by using dates; how to retrieve information relating to dates in the past, present, and future; and how to use ranking formulas to find smallest and largest values in a list. Next, learn how to extract data and separate values into separate cells; how to combine existing data values in a single cell; and how to analyze complex tables with multiple arrays to obtain summarized results. Continue by observing how to use VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values; how to use conditional formulas to perform a search across multiple tables and automatically insert data; and how to use VLOOKUP formula to cross-reference data lists and retrieve corresponding values. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Finding & Analyzing Information with Formulas Exercise as well as the associated materials in the Resources section.
WHAT YOU WILL LEARN
-
Use dates to retrieve information
Find a date automatically
Find the largest and smallest values in a list
Separate data into multiple cells
Combine data values in a single cell -
Create automatic reports
Cross-reference data with formulas
Perform a search across tables
Use formulas to insert data automatically
IN THIS COURSE
-
4m 56sExcel 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. FREE ACCESS
-
3m 17sSome 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. FREE ACCESS
-
3. Finding the largest & smallest values in a list in Excel 2019 for Windows4m 1sExcel'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. FREE ACCESS
-
4. Separating data into multiple cells in Excel 2019 for Windows6m 23sIf 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. FREE ACCESS
-
5. Combining data values in a single cell in Excel 2019 for Windows3m 22sThe CONCATENATE formula can be used in Excel to combine in a single cell data taken from multiple cells in your worksheet. FREE ACCESS
-
6. Creating automatic reports in Excel 2019 for Windows2m 56sThe 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. FREE ACCESS
-
7. Cross-referencing data with formulas in Excel 2019 for Windows3m 16sIn Excel, you can use the VLOOKUP and HLOOKUP formulas to cross-reference the contents of two lists. This is very useful when checking for missing values in your lists. FREE ACCESS
-
8. Performing a search across two tables in Excel 2019 for Windows4m 4sIn 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. FREE ACCESS
-
9. Inserting data automatically with formulas in Excel 2019 for Windows4m 26sIn 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. 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.
