Filtering and sorting data in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 Videos | 34m 33s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
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.

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
    FREE ACCESS
  • Locked
    4. 
    Building filter arguments
    4m 26s
    FREE ACCESS
  • Locked
    5. 
    Performing advanced filtering
    2m 58s
    FREE ACCESS
  • Locked
    6. 
    Filtering and sorting using colors
    2m 53s
    FREE ACCESS
  • Locked
    7. 
    Sorting the data
    3m 14s
    FREE ACCESS
  • Locked
    8. 
    Applying multiple sort levels
    3m 59s
    FREE ACCESS
  • Locked
    9. 
    Using custom sort lists
    4m 8s
    FREE ACCESS
  • Locked
    10. 
    Performing advanced sorting
    2m 55s
    FREE ACCESS
  • Locked
    11. 
    Hiding and removing duplicate values in Excel 365
    2m 48s
    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 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

COURSE Finding and grouping data in Excel 365
COURSE Customizing text & number formats in Excel 365
Likes 1 Likes 1  
COURSE Printing spreadsheets in Excel 365
Likes 2 Likes 2