Sorting & Filtering Data

Excel Microsoft 365 (Windows)    |    Intermediate
  • 10 Videos | 44m 11s
  • Includes Assessment
  • Earns a Badge
Likes 133 Likes 133
This 10-video course offers learners an in-depth exploration of Excel's sorting and filtering tools used to analyze data in a spreadsheet. You will learn how to control what is displayed in a data range, and how the values are organized in a worksheet. This course then demonstrates how to sort a data range by alphabetical order, and in value ranges. Learn how to include or exclude a header, and change the sort orientation from vertical to horizontal. Then learn how to create multiple sort levels to change how data are presented. You will learn how to create a custom sort list, and how to use column filters to show or hide different data values in your data range. You will learn to filter the data of a range and show values to meet specified criteria. This course demonstrates how to apply color coding to data items in a table, and how to use these codes to sort and filter data. Finally, learners observe how to create advanced filter criteria by using a separate table.

WHAT YOU WILL LEARN

  • sort data in a worksheet according to a specific data type
    customize sort options when sorting data in a worksheet
    sort data using multiple criteria and sort levels
    create and use custom sort lists to sort data
    use column filters to filter data in a worksheet
  • use column filters to apply multiple filters to data in a worksheet
    create filter arguments using text and number data types
    sort and filter data using colors applied to data
    use the advanced filter tools to filter and extract data
    use filter tools to hide duplicate values in a data range

IN THIS COURSE

  • Playable
    1. 
    Sorting your data
    4m 16s
    UP NEXT
  • Playable
    2. 
    Using the advanced sorting tools
    3m 28s
  • Locked
    3. 
    Applying multiple sort levels
    3m 44s
  • Locked
    4. 
    Using custom sort lists
    4m 46s
  • Locked
    5. 
    Filtering your data
    4m
  • Locked
    6. 
    Applying multiple filters
    2m 20s
  • Locked
    7. 
    Building filter arguments
    4m 31s
  • Locked
    8. 
    Sorting & filtering using colors
    2m 41s
  • Locked
    9. 
    Using the advanced filter options
    5m 5s
  • Locked
    10. 
    Hiding duplicate values
    4m 20s

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 705 Likes 705  
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 705 Likes 705  
Likes 129 Likes 129  
Likes 206 Likes 206