Filtering and sorting data in Excel 365

IN THIS COURSE

• 1.  Course Overview: Filtering and sorting data in Excel 365
  50s
  This video outlines the key content covered in the Microsoft 365: Filtering and sorting data in Excel 365 course, including how to apply multiple filters to worksheet data, perform advanced filtering, apply multiple sort levels, and how to hide duplicate values. FREE ACCESS
• 2.  Filtering the data
  3m 29s
  In Excel 365, you can choose to show or hide different types of data, which is known as filtering. If you do not need a particular category or type of data, you can specify criteria to include or exclude, or indicate the value that you want to visualize. In this video, you will explore how to use filter tools to focus on a specific data group in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 3.3.1 Filter records. FREE ACCESS
• 3.  Applying multiple filters
  2m 52s
  Column filters can be useful if you'd like to quickly show or hide different data values in a data range in Excel 365, but you can apply multiple filters to one or more columns of a worksheet to refine the data further. In this video, you will explore how to use column controls to apply multiple filters to the data in an Excel 365 worksheet. FREE ACCESS
• 4.  Building filter arguments
  4m 26s
  In Excel 365, filter arguments can be used to query the data within a cell range and show values that meet defined filter criteria, such as equals, contains, and between. You can even add multiple arguments using "and" and "or." In this video, you will discover how to create filters using text and numeric arguments in Excel 365. FREE ACCESS
• 5.  Performing advanced filtering
  2m 58s
  In Excel 365, you can use a separate table to create advanced filter criteria. Once you have defined the filter criteria, you can launch a filter by defining the 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. In this video, you will explore how to use the advanced filter tools in Excel 365. FREE ACCESS
• 6.  Filtering and sorting using colors
  2m 53s
  If you have applied colored fills to various data entries in a table, you can use those colors to filter and sort the data. You might, for example, want to visualize only the values that have been highlighted in red. In this video, you will explore how to filter and sort values by color in Excel 365. FREE ACCESS
• 7.  Sorting the data
  3m 14s
  In Excel 365, you can use sort options to organize and order the data in a table. You can specify the criteria that you want to use: you can, for example, sort a data range using alphabetical order or from smallest to largest value. In this video, you will explore how to sort data in Excel 365. FREE ACCESS
• 8.  Applying multiple sort levels
  3m 59s
  In Excel 365, you can create multiple sort levels to change how data is presented. And you can create data groups within a cell range. You can also reorganize these levels to adjust how your data is grouped when sorting. In this video, you will explore how to apply multiple sort levels in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.3.2 Sort data by multiple columns. FREE ACCESS
• 9.  Using custom sort lists
  4m 8s
  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. In this video, you will explore how to apply a custom sort list in Excel 365. FREE ACCESS
• 10.  Performing advanced sorting
  2m 55s
  Excel 365 offers a number of additional tools that you can use to change how you sort your data. You can include or exclude header data in your operation, change the sort orientation from vertical to horizontal, and apply case-sensitive sorting. In this video, you will explore how to perform advanced sorting in Excel 365. FREE ACCESS
• 11.  Hiding and removing duplicate values in Excel 365
  2m 48s
  Excel 365 features a Remove Duplicates command that can be used to find and delete duplicate values that exist in a data table or cell range. In this video, you will discover how to remove duplicate values in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 2.2.5 Remove duplicate records. FREE ACCESS