Administration and Executive AssistantTier 145 minbeginner

AutoFilter: The 80/20 Tool

Hide rows without deleting them, and slice data without formulas.

What you will learn

• Apply AutoFilter and use dropdown menus
• Filter by multiple criteria and by color
• Use Text and Number filters for ranges
• Understand what happens to row numbers during filtering

Excel skills

AutoFilter, filter dropdowns, filter criteria · Data Filtering

The task

Sixty invoices on the Invoices tab. I need to know how many are overdue and what they add up to, on the Summary tab.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free