Excel 202: Sort, Filter, and Conditional Formatting
In this live training event, we focus on sorting and filtering data in Excel. Sorting is the process of ordering all data in a certain way. Filtering is distinct from sorting: it takes your criteria and returns only records that match. Both of these features play an important role in organizing and displaying your data.
Recommended Duration: 45-minutes + Q & A
Core Objectives
- Perform single and multi-level sorts
- Create subtotals
- Remove subtotals
- Create nested subtotals
- Find data using the find feature
- Use the filter
- Use multiple filter criteria
- Clear filters
- Optional: Work with conditional formatting
