Translations:Basic Excel/39/en
Autofilters allow you to:
- find values in your dataset quickly
- identify groups used (for categorical data)
- identify minimum and maximum values (for numerical data)
- find outliers (extreme or aberrant values)
- locate missing values