Finding, Sorting, & Filtering Data in Excel 2016 for Mac
Excel 2016 (Mac)
| Intermediate
- 9 videos | 29m 13s
- Earns a Badge
In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.
WHAT YOU WILL LEARN
-
use the Find tool in Excel 2016 for Macuse the Replace tool in Excel 2016 for Macsort your data in Excel 2016 for Macfilter your data in Excel 2016 for Macsort and filter using colors in Excel 2016 for Mac
-
use advanced filter options in Excel 2016 for Macfreeze and unfreeze panes in your worksheetscreate groups in Excel 2016 for Machide duplicate values in Excel 2016 for Mac
IN THIS COURSE
-
1.Using the Find tool in Excel 2016 for Mac2m 55sUP NEXT
-
2.Using the Replace tool in Excel 2016 for Mac3m 16s
-
3.Sorting your data in Excel 2016 for Mac2m 46s
-
4.Filtering your data in Excel 2016 for Mac3m 34s
-
5.Sorting & filtering using colors in Excel 2016 for Mac2m 4s
-
6.Using the advanced filter options in Excel 2016 for Mac3m 44s
-
7.Freezing & unfreezing panes in Excel 2016 for Mac3m 53s
-
8.Grouping items & creating an outline in Excel 2016 for Mac4m 22s
-
9.Hiding duplicate values in Excel 2016 for Mac2m 40s
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.