Activate the AutoFilter feature from the Data tab to begin filtering your data;
Apply multiple filters to fine-tune your dataset based on varied criteria;
Use the Clear Filter option to reset your data view to its original state;
Employ advanced filtering options to specify more complex filter conditions.

Task

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Task

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Mark tasks as Completed

Everything was clear?

Section 5. Chapter 2

Choose your plan

Filtering Data Using AutoFilter

Imagine having a magic magnifying glass that only shows you the data you need. That's what using AutoFilter in Excel is like.

We'll go through how to use this tool to highlight the essential information, helping you to ignore the noise and focus on what's important.

Activate the AutoFilter feature from the Data tab to begin filtering your data;
Apply multiple filters to fine-tune your dataset based on varied criteria;
Use the Clear Filter option to reset your data view to its original state;
Employ advanced filtering options to specify more complex filter conditions.

Task

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Task

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Mark tasks as Completed

Everything was clear?

Section 5. Chapter 2

Imagine having a magic magnifying glass that only shows you the data you need. That's what using AutoFilter in Excel is like.

We'll go through how to use this tool to highlight the essential information, helping you to ignore the noise and focus on what's important.

Activate the AutoFilter feature from the Data tab to begin filtering your data;
Apply multiple filters to fine-tune your dataset based on varied criteria;
Use the Clear Filter option to reset your data view to its original state;
Employ advanced filtering options to specify more complex filter conditions.

Task

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Task

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Everything was clear?

Imagine having a magic magnifying glass that only shows you the data you need. That's what using AutoFilter in Excel is like.

We'll go through how to use this tool to highlight the essential information, helping you to ignore the noise and focus on what's important.

Activate the AutoFilter feature from the Data tab to begin filtering your data;
Apply multiple filters to fine-tune your dataset based on varied criteria;
Use the Clear Filter option to reset your data view to its original state;
Employ advanced filtering options to specify more complex filter conditions.

Task

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Section 5. Chapter 2

Switch to desktop for real-world practiceContinue from where you are using one of the options below