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
    FREE ACCESS
  • Locked
    4. 
    Sorting data in a table in Excel 2010 for Windows
    3m 59s
    FREE ACCESS
  • Locked
    5. 
    Filtering data in a table in Excel 2010 for Windows
    3m 29s
    FREE ACCESS
  • Locked
    6. 
    Sorting & filtering using colors in Excel 2010 (Windows)
    3m 11s
    FREE ACCESS
  • Locked
    7. 
    Using the advanced filter options in Excel 2010 for Windows
    2m 44s
    FREE ACCESS
  • Locked
    8. 
    Hiding duplicate values in Excel 2010 for Windows
    2m 24s
    FREE ACCESS
  • Locked
    9. 
    Freezing & unfreezing panes in Excel 2010 for Windows
    2m 42s
    FREE ACCESS
  • Locked
    10. 
    Grouping elements & creating a plan in Excel 2010 for Windows
    2m 59s
    FREE ACCESS

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

Book Excel All-in-One For Dummies
Course Manipulating PivotTable data in Excel 365
Channel Excel
Likes 4322 Likes 4322  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Referencing Data in Excel 2010 for Windows
Likes 17 Likes 17  
Course Resolving Workplace Conflict
Likes 622 Likes 622  
Course Choosing and Using the Best Solution
Likes 718 Likes 718