Finding, Sorting, & Filtering Data in Excel 2016 for Mac

Excel 2016 (Mac)    |    Intermediate
  • 9 videos | 29m 13s
  • Earns a Badge
Likes 10 Likes 10
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 Mac
    use the Replace tool in Excel 2016 for Mac
    sort your data in Excel 2016 for Mac
    filter your data in Excel 2016 for Mac
    sort and filter using colors in Excel 2016 for Mac
  • use advanced filter options in Excel 2016 for Mac
    freeze and unfreeze panes in your worksheets
    create groups in Excel 2016 for Mac
    hide duplicate values in Excel 2016 for Mac

IN THIS COURSE

  • Playable
    1. 
    Using the Find tool in Excel 2016 for Mac
    2m 55s
    UP NEXT
  • Playable
    2. 
    Using the Replace tool in Excel 2016 for Mac
    3m 16s
  • Locked
    3. 
    Sorting your data in Excel 2016 for Mac
    2m 46s
    FREE ACCESS
  • Locked
    4. 
    Filtering your data in Excel 2016 for Mac
    3m 34s
    FREE ACCESS
  • Locked
    5. 
    Sorting & filtering using colors in Excel 2016 for Mac
    2m 4s
    FREE ACCESS
  • Locked
    6. 
    Using the advanced filter options in Excel 2016 for Mac
    3m 44s
    FREE ACCESS
  • Locked
    7. 
    Freezing & unfreezing panes in Excel 2016 for Mac
    3m 53s
    FREE ACCESS
  • Locked
    8. 
    Grouping items & creating an outline in Excel 2016 for Mac
    4m 22s
    FREE ACCESS
  • Locked
    9. 
    Hiding duplicate values in Excel 2016 for Mac
    2m 40s
    FREE ACCESS

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.

YOU MIGHT ALSO LIKE

Course Analyzing & Manipulating Data Entries in Excel for the Web
Likes 10 Likes 10  
Course Manipulating PivotTable data in Excel 365
Course Filtering and sorting data in Excel 365