Filter Definition in Excel:
A filter in excel is essential as we don’t need to analyze the whole data and focus on a particular data set.
Explanation with Example Questions:
Brenda is a homemaker who also bakes cakes for some extra money. At the end of the month, she goes to the bakeries to get her money, who gave her cake orders.
Today, Brenda is not feeling well, so she thought to send her children to collect the money from the bakeries.
She saw an opportunity in this situation of teaching the new concept of filter in excel.
After Carl and Carly came home after collecting the money, she gave them the task of making an excel sheet out of it. And solve these questions:
- Sort the list in ascending and descending order according to the amount received.
- Filter out the bakeries that paid more than $190.
- Remove the filters.
Both the children tried their hardest. They both tried solving the questions using the universal copy and paste method, but its time consuming; Brenda couldn’t see her children struggling, so she explained them.
Sorting in Ascending or descending order
- First, select the column of ‘Amount received’.
- Go to the ‘Data’ option in the top menu.
- Select ‘Filter’.
- Click on the small arrow that appears on the column header and a menu will appear.
- Select ‘Sort Smallest to Largest’ or ‘Sort Largest to Smallest’ to sort in ascending and descending order resp.
Filter out the bakeries that paid more than $190
- First, select the column of ‘Amount received’.
- Go to the ‘Data’ option in the top menu.
- Select ‘Filter’.
- Click on the small arrow that appears on the column header; a menu will appear.
- Select ‘Number Filters’ and then select ‘Greater Than’ and
- A ‘custom autofilter’ window will open and fill 190 as we want >190.
To remove all the filters, go to the ‘data’ option in the menu and click on the ‘filter’, it will remove all the applied filters.
Learn about the Mail Merge in Excel
So, another day ends with another great excel lesson for the children.