Finding, Sorting, & Filtering Data

Excel 2010 (Windows)    |    Intermediate
  • 10 Videos | 33m 54s
  • Earns a Badge
Likes 19 Likes 19
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

  • Using the Find tool
    Using the Replace tool
    Using the Find & Replace tools in a formula
    Sorting data in a table
    Filtering data in a table
  • Sorting & filtering using colors
    Using the advanced filter options
    Hiding duplicate values
    Freezing & unfreezing panes
    Grouping elements & creating a plan

IN THIS COURSE

  • Playable
    1. 
    Using the Find tool
    3m 57s
    UP NEXT
  • Playable
    2. 
    Using the Replace tool
    3m 43s
  • Locked
    3. 
    Using the Find & Replace tools in a formula
    3m 18s
  • Locked
    4. 
    Sorting data in a table
    3m 59s
  • Locked
    5. 
    Filtering data in a table
    3m 29s
  • Locked
    6. 
    Sorting & filtering using colors
    3m 11s
  • Locked
    7. 
    Using the advanced filter options
    2m 44s
  • Locked
    8. 
    Hiding duplicate values
    2m 24s
  • Locked
    9. 
    Freezing & unfreezing panes
    2m 42s
  • Locked
    10. 
    Grouping elements & creating a plan
    2m 59s

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.

YOU MIGHT ALSO LIKE

Likes 13 Likes 13  
Likes 129 Likes 129  
Likes 13 Likes 13  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 229 Likes 229  
Likes 704 Likes 704  
COURSE Tools
Likes 72 Likes 72