Finding, Sorting, & Filtering Data

Excel 2010 (Windows)
  • 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 41 Likes 41  
COURSE Managing Data
Likes 25 Likes 25  
Likes 82 Likes 82  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1408 Likes 1408  
Likes 61 Likes 61  
Likes 238 Likes 238