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.