Sorting & Filtering Data in Excel 2019 for Windows

Excel 2019 (Windows)    |    Intermediate
  • 10 videos | 37m 42s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.6 of 785 users Rating 4.6 of 785 users (785)
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. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Sorting & Filtering Data Exercise as well as the associated materials in the Resources section.

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

  • 3m 50s
    Excel's sort options can be used to organize and order the data in your table. You can specify the criteria that you use: you can, for example, sort a data range using alphabetical order or from smallest to largest value. FREE ACCESS
  • 3m 1s
    Excel offers a number of additional tools that you can use to change how you sort your data. See how to include or exclude header data in your operation, change the sort orientation from vertical to horizontal, and apply case sensitive sorting. FREE ACCESS
  • Locked
    3.  Applying multiple sort levels in Excel 2019 for Windows
    3m 48s
    In Excel, you can create multiple sort levels to change how your data is presented and create data groups within your range. You can also reorganize these levels to adjust how your data is grouped when sorting. FREE ACCESS
  • Locked
    4.  Using custom sort lists in Excel 2019 for Windows
    4m 36s
    When sorting data, you can use or create custom sort lists for data that doesn't sort alphabetically. This is particularly useful if your data contains days of the week or months of the year, or if you are sorting data that features text-based ranking systems, such as low, high, and urgent priorities. FREE ACCESS
  • Locked
    5.  Filtering your data in Excel 2019 for Windows
    3m 3s
    In Excel, you can choose to show or hide different types of data. This is known as filtering. If you do not need a particular category or type of data, or if you want to focus on a specific data group, you can use the filter tools. You can specify criteria to include or exclude, or indicate the value that you want to visualize. FREE ACCESS
  • Locked
    6.  Applying multiple filters in Excel 2019 for Windows
    2m 38s
    Column filters can be used to quickly show or hide different data values in your data range. You can use these column controls to apply multiple filters to your data. FREE ACCESS
  • Locked
    7.  Building filter arguments in Excel 2019 for Windows
    5m 23s
    Filter arguments can be used to query the data in your range and show values that meet your defined criteria. You can create filters using text and numeric arguments, such as equals, contains, and between, and even add multiple arguments using "and" and "or". FREE ACCESS
  • Locked
    8.  Sorting & filtering using colors in Excel 2019 for Windows
    3m 27s
    If you have applied color coding to various data entries in your table, you can use these codes to sort and filter your data. You might, for example, want to visualize only the values that have been highlighted in red. FREE ACCESS
  • Locked
    9.  Using the advanced filter options in Excel 2019 for Windows
    5m 27s
    In Excel, you can create advanced filter criteria using a separate table. Once you have defined your criteria, you can launch the filter by defining your data range and selecting the cells you want to use as criteria. These criteria cells can be combined as much as you want to create powerful filter operations. FREE ACCESS
  • Locked
    10.  Hiding duplicate values in Excel 2019 for Windows
    2m 29s
    Excel features an advanced filter tool that can be used to temporarily hide any duplicates that have been added to your data table. All you need to do is select the data range to be filtered and the location of your table. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.5 of 27 users Rating 4.5 of 27 users (27)
Rating 4.5 of 380 users Rating 4.5 of 380 users (380)
Rating 4.5 of 1324 users Rating 4.5 of 1324 users (1324)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 487 users Rating 4.5 of 487 users (487)
Rating 4.5 of 455 users Rating 4.5 of 455 users (455)
Rating 4.5 of 327 users Rating 4.5 of 327 users (327)