Explanation

Sorting and filtering help organize large datasets and quickly find the information you need.

Key Concepts

  • Sort A to Z / Z to A
  • Smallest to Largest / Largest to Smallest
  • Sort by multiple columns
  • AutoFilter
  • Filter by Text, Number and Date
  • Clear and Reapply Filters

Example

Sort a sales dataset by Sales Amount → Largest to Smallest.

Practice

Sort the business dataset:

  1. By City
  2. By Product
  3. By Sales Amount
  4. By Date
PreviousNext