Finding, Sorting & Filtering Data

Excel 2016 (Windows)    |    Intermediate
  • 11 Videos | 45m 50s
  • Includes Assessment
  • Earns a Badge
Likes 82 Likes 82
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
    5m
    UP NEXT
  • Playable
    2. 
    Using the Replace tool
    4m 8s
  • Locked
    3. 
    Using the Find & Replace tools in a formula
    2m 48s
  • Locked
    4. 
    Sorting your data
    4m 59s
  • Locked
    5. 
    Filtering your data
    4m 42s
  • Locked
    6. 
    Sorting & filtering using colors
    3m 9s
  • Locked
    7. 
    Using slicers in tables
    6m 8s
  • Locked
    8. 
    Using the advanced filter options
    3m 49s
  • Locked
    9. 
    Hiding duplicate values
    2m 3s
  • Locked
    10. 
    Freezing & unfreezing panes
    4m 23s
  • Locked
    11. 
    Grouping items & creating an outline
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 66 Likes 66  
Likes 1408 Likes 1408  
Likes 809 Likes 809