Finding, Sorting & Filtering Data in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 11 videos | 45m 50s
  • Includes Assessment
  • Earns a Badge
Likes 131 Likes 131
Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.

WHAT YOU WILL LEARN

  • Using the Find tool
    Using the Replace tool
    Using the Find & Replace tools in a formula
    Sorting your data
    Filtering your data
    Sorting & filtering using colors
  • Using slicers in tables
    Using the advanced filter options
    Hiding duplicate values
    Freezing & unfreezing panes
    Grouping items & creating an outline

IN THIS COURSE

  • Playable
    1. 
    Using the Find tool in Excel 2016 for Windows
    5m
    UP NEXT
  • Playable
    2. 
    Using the Replace tool in Excel 2016 for Windows
    4m 8s
  • Locked
    3. 
    Using the Find & Replace tools in a formula in Excel 2016 for Windows
    2m 48s
  • Locked
    4. 
    Sorting your data in Excel 2016 for Windows
    4m 59s
  • Locked
    5. 
    Filtering your data in Excel 2016 for Windows
    4m 42s
  • Locked
    6. 
    Sorting & filtering using colors in Excel 2016 for Windows
    3m 9s
  • Locked
    7. 
    Using slicers in tables in Excel 2016 for Windows
    6m 8s
  • Locked
    8. 
    Using the advanced filter options in Excel 2016 for Windows
    3m 49s
  • Locked
    9. 
    Hiding duplicate values in Excel 2016 for Windows
    2m 3s
  • Locked
    10. 
    Freezing & unfreezing panes in Excel 2016 for Windows
    4m 23s
  • Locked
    11. 
    Grouping items & creating an outline in Excel 2016 for Windows
    4m 41s

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 231 Likes 231  
Likes 335 Likes 335