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 dates
find dates automatically using formulas
find the smallest and largest values in a list
separate data into multiple cells
combine data values in a single cell -
insert data automatically into Excel 2016 for Ma
retrieve information using the CELL formula
retrieve information from your text-based data
find data in a database in Excel 2016 for Mac
perform 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.
