Extracting Information with Formulas in Excel 2016 for Mac
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 dates in Excel 2016 for Mac3m 46sUP NEXT
-
2.Finding a date automatically in Excel 2016 for Mac6m 4s
-
3.Finding the largest & smallest values in a list in Excel 2016 for Mac5m 20s
-
4.Separating data into multiple cells in Excel 2016 for Mac4m 50s
-
5.Combining data values in a single cell in Excel 2016 for Mac2m 24s
-
6.Inserting data automatically in Excel 2016 for Mac4m 20s
-
7.Retrieving information on a cell in Excel 2016 for Mac3m 28s
-
8.Retrieving information on your text in Excel 2016 for Mac2m 37s
-
9.Finding data in a database in Excel 2016 for Mac6m 7s
-
10.Performing calculations using your database in Excel 2016 for Mac4m 28s
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.