Finding & Analyzing Information with Formulas
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 informationfind a date automaticallyfind the largest and smallest values in a listseparate data into multiple cellscombine data values in a single cell
-
create automatic reportscross-reference data with formulasperform a search across tablesuse formulas to insert data automatically
IN THIS COURSE
-
1.Retrieving information with dates4m 56sUP NEXT
-
2.Finding a date automatically3m 17s
-
3.Finding the largest & smallest values in a list4m 1s
-
4.Separating data into multiple cells6m 23s
-
5.Combining data values in a single cell3m 22s
-
6.Creating automatic reports2m 56s
-
7.Cross-referencing data with formulas3m 16s
-
8.Performing a search across two tables4m 4s
-
9.Inserting data automatically with formulas4m 26s
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.