How to Create Filter in Excel
Aug 14, 2023
How to Create Filter in Excel
In this video tutorial, we’ll cover how to create a filter in Excel. At the end of the session, you’ll be able to filter out relevant data within a table effectively. Let’s have a look!https://www.easyclickacademy.com/how- …https://www.easyclickacademy.com/buy- …https://www.paypal.com/cgi-bin/webscr …https://www.linkedin.com/company/easy …https://www.facebook.com/EasyClickAca …https://techsmith.pxf.io/c/1266206/34 …https://seanantonyvo.com
Content
0.08 -> Welcome!
1.36 -> In this video tutorial will cover how to create a filter in Excel.
5.72 -> At the end of the session, you’ll be able to filter out relevant data within a table effectively.
10.84 -> Let’s have a look!
16.26 -> Hello! And welcome to EasyClick Academy!
18.36 -> My name’s Frank and together with our EasyClick team,
20.96 -> we’re here to make sure you’ll be able to use Excel in a quick and easy way,
24.8 -> thanks to our digestible video tutorials.
27.5 -> To see how to create a filter in Excel, we’ll use this table as an example.
32.24 -> The first thing to do, if you want to use the filter function in a table,
36.2 -> is to use headers to select the columns in which you want to apply the filter.
40.22 -> Let’s select the headers ‘Month’, ‘Days’ and ‘Season’ now.
45.56 -> Click on the ‘Data’ tab and look for the group ‘Sort & Filter.
49.06 -> Then find and click on the ‘Filter’ option.
52.58 -> Excel will create these drop-down arrows (or buttons)
56.1 -> in the cells containing the headers of the selected columns.
59.32 -> You can use the buttons to filter out the information you need in each column.
63.38 -> Now, it’s time to take a step forward and try out the filter we’ve just created in practice.
68.74 -> Let’s say we want to filter out only the summer months.
71.94 -> Click on the drop-down arrow in the column ‘Season’.
74.92 -> All of the options are selected by default.
77.44 -> Unselect the options by clicking on ‘Select All’.
80.3 -> Now tick the box next to the option which we want to filter out, which is ‘Summer’.
86.04 -> Confirm with OK and you see that only the summer months are now displayed in the table.
91.82 -> If you have a look at row numbers, you’ll see that the rows with data for other months have not been deleted.
97.3 -> They’re only hidden.
98.9 -> Look, there’s row 2 and rows 8, 9 and 10 follow right after.
104.14 -> Then the next row number you can see is 15.
107.32 -> Now we can carry on.
109.52 -> Imagine you need to do some more filtering, let’s say you want to filter out months that have thirty-one days only.
115.76 -> We’ll do what you’re already familiar with.
118.52 -> Click on the drop-down arrow in the column ‘Days’, click on ‘Select All’,
122.76 -> and once everything’s been unselected, tick the box for only those months that have thirty-one days,
128.66 -> so select ‘31’.
131.04 -> Click on OK and here we go!
134.1 -> We’ve used filter to show only those summer months that have thirty-one days.
138.86 -> Easy, right?
140.04 -> You can follow these steps to filter out data in any table you need.
144.52 -> To see how you can remove the filter from the table, watch the next video tutorial by EasyClick Academy!
150.72 -> If you found this tutorial helpful, give us a like and watch other video tutorials by EasyClick Academy.
156.7 -> Learn how to use Excel in a quick and easy way!
159.68 -> Is this your first time on EasyClick?
161.84 -> We’ll be more than happy to welcome you in our online community.
164.9 -> Hit that Subscribe button and join the EasyClickers.
168.02 -> Thanks for watching and I’ll see you in the next video!
Source: https://www.youtube.com/watch?v=04_kOwCnyog
