Sorting & Filtering Data

Excel 2019 (Windows)
  • 10 Videos | 52m 42s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 52 Likes 52
The first step in analyzing the data in a worksheet is often taken with Excel's sorting and filtering tools. These tools help you to control what is displayed in your data range, and how the values are organized. Key concepts covered in this 10-video course include how to sort data in a worksheet according to a specific data type; how to customize sort options when sorting data in a worksheet and sort data by using multiple criteria and sort levels; and how to create and use custom sort lists to sort data. Next, learn how to use column filters to filter data in a worksheet; to use column filters to apply multiple filters to data in a worksheet; and to create filter arguments by using text and number data types. Finally, you will learn to sort and filter data by using colors applied to data; learn to use the advanced filter tools to filter and extract data; and learn to use filter tools to hide duplicate values in a data range.

WHAT YOU WILL LEARN

  • sort data in a worksheet
    use the advanced sorting tools
    apply multiple sort levels
    create and use custom sort lists
    filter data in a worksheet
  • apply multiple filters
    build filter arguments
    sort and filter using colors
    use the advanced filter options
    hide duplicate values

IN THIS COURSE

  • Playable
    1. 
    Sorting your data
    3m 50s
    UP NEXT
  • Playable
    2. 
    Using the advanced sorting tools
    3m 1s
  • Locked
    3. 
    Applying multiple sort levels
    3m 48s
  • Locked
    4. 
    Using custom sort lists
    4m 36s
  • Locked
    5. 
    Filtering your data
    3m 3s
  • Locked
    6. 
    Applying multiple filters
    2m 38s
  • Locked
    7. 
    Building filter arguments
    5m 23s
  • Locked
    8. 
    Sorting & filtering using colors
    3m 27s
  • Locked
    9. 
    Using the advanced filter options
    5m 27s
  • Locked
    10. 
    Hiding duplicate values
    2m 29s

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 212 Likes 212  
Likes 75 Likes 75  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 279 Likes 279  
Likes 132 Likes 132  
Likes 74 Likes 74