Conteúdo do Curso
Excel Essentials
Excel Essentials
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.
Key Points
- 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.
Tarefa
- 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].
Tarefa
- 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].
Tudo estava claro?
Escolha seu plano
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.
Key Points
- 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.
Tarefa
- 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].
Tarefa
- 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].
Tudo estava claro?
Escolha seu plano
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.
Key Points
- 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.
Tarefa
- 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].
Tarefa
- 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].
Tudo estava claro?
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.
Key Points
- 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.
Tarefa
- 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].