Finding, Sorting, & Filtering Data in Excel 2010 for Windows

Excel 2010 (Windows)    |    Intermediate
  • 10 videos | 32m 24s
  • Earns a Badge
Likes 29 Likes 29
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 in Excel 2010 for Windows
    3m 57s
    UP NEXT
  • Playable
    2. 
    Using the Replace tool in Excel 2010 for Windows
    3m 43s
  • Locked
    3. 
    Using the Find & Replace tools in a formula in Excel 2010 for Windows
    3m 18s
  • Locked
    4. 
    Sorting data in a table in Excel 2010 for Windows
    3m 59s
  • Locked
    5. 
    Filtering data in a table in Excel 2010 for Windows
    3m 29s
  • Locked
    6. 
    Sorting & filtering using colors in Excel 2010 (Windows)
    3m 11s
  • Locked
    7. 
    Using the advanced filter options in Excel 2010 for Windows
    2m 44s
  • Locked
    8. 
    Hiding duplicate values in Excel 2010 for Windows
    2m 24s
  • Locked
    9. 
    Freezing & unfreezing panes in Excel 2010 for Windows
    2m 42s
  • Locked
    10. 
    Grouping elements & creating a plan in Excel 2010 for Windows
    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 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 17 Likes 17  
Likes 622 Likes 622  
Likes 718 Likes 718