Filtering and sorting data in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 11 Videos | 46m 5s
  • 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
    1m 3s
    UP NEXT
  • Playable
    2. 
    Filtering the data
    4m 42s
  • Locked
    3. 
    Applying multiple filters
    3m 52s
    FREE ACCESS
  • Locked
    4. 
    Building filter arguments
    5m 59s
    FREE ACCESS
  • Locked
    5. 
    Performing advanced filtering
    4m 2s
    FREE ACCESS
  • Locked
    6. 
    Filtering and sorting using colors
    3m 57s
    FREE ACCESS
  • Locked
    7. 
    Sorting the data
    4m 29s
    FREE ACCESS
  • Locked
    8. 
    Applying multiple sort levels
    5m 26s
    FREE ACCESS
  • Locked
    9. 
    Using custom sort lists
    5m 38s
    FREE ACCESS
  • Locked
    10. 
    Performing advanced sorting
    4m
    FREE ACCESS
  • Locked
    11. 
    Removing duplicate values
    2m 58s
    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 & Grouping Data
Likes 129 Likes 129  
COURSE Finding, Sorting & Filtering Data
Likes 8 Likes 8  
COURSE Working with Excel Tables
Likes 212 Likes 212