Filtering and sorting data in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 Videos | 34m 33s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Excel 365 includes various sort and filtering tools, which you can use to analyze the data in a worksheet. You can use these tools to organize and choose what values are shown in a range. The key concepts in this course include how to use filter tools and how to remove duplicate values in a data range. See how to use column filters to filter data and apply multiple filters to values in a worksheet. Create filter arguments using text and number data types to show values that meet defined filter criteria. Finally, you will learn how to sort and filter data according to their background fill color; sort data in a worksheet according to a specific data type; customize the sort options; apply multiple criteria and sort levels, and create and use custom sort lists. In order to practice what you have learned, you will find practice exercises and samples in the Resources section.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this Microsoft 365: Filtering and sorting data in Excel 365 course
    use column filters to filter worksheet data in Excel 365
    apply multiple filters to worksheet data in Excel 365
    create filter arguments in Excel 365
    use the advanced filter tools in Excel 365
    filter and sort data by color in Excel 365
  • sort data in a worksheet in Excel 365
    sort data using multiple sort levels in Excel 365
    create and use a custom sort list in Excel 365
    perform an advanced sort in Excel 365
    remove duplicate values from a range in Excel 365

IN THIS COURSE

  • Playable
    1. 
    Course Overview: Filtering and sorting data in Excel 365
    50s
    UP NEXT
  • Playable
    2. 
    Filtering the data
    3m 29s
  • Locked
    3. 
    Applying multiple filters
    2m 52s
  • Locked
    4. 
    Building filter arguments
    4m 26s
  • Locked
    5. 
    Performing advanced filtering
    2m 58s
  • Locked
    6. 
    Filtering and sorting using colors
    2m 53s
  • Locked
    7. 
    Sorting the data
    3m 14s
  • Locked
    8. 
    Applying multiple sort levels
    3m 59s
  • Locked
    9. 
    Using custom sort lists
    4m 8s
  • Locked
    10. 
    Performing advanced sorting
    2m 55s
  • Locked
    11. 
    Hiding and removing duplicate values in Excel 365
    2m 48s

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.