Extracting Information with Formulas
Excel 2016 (Mac)
| Intermediate
- 10 Videos | 43m 24s
- Earns a Badge
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, including MAX, MIN, LARGE, SMALL, CONCAT, and VLOOKUP.
WHAT YOU WILL LEARN
-
retrieve information with datesfind dates automatically using formulasfind the smallest and largest values in a listseparate data into multiple cellscombine data values in a single cell
-
insert data automatically into Excel 2016 for Maretrieve information using the CELL formularetrieve information from your text-based datafind data in a database in Excel 2016 for Macperform calculations using your data
IN THIS COURSE
-
1.Retrieving information with dates3m 46sUP NEXT
-
2.Finding a date automatically6m 4s
-
3.Finding the largest & smallest values in a list5m 20s
-
4.Separating data into multiple cells4m 50s
-
5.Combining data values in a single cell2m 24s
-
6.Inserting data automatically4m 20s
-
7.Retrieving information on a cell3m 28s
-
8.Retrieving information on your text2m 37s
-
9.Finding data in a database6m 7s
-
10.Performing calculations using your database4m 28s
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.YOU MIGHT ALSO LIKE
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

BOOK
Excel 2019 Bible