Know How to Filter Data in Microsoft Excel

In this blog post, you learn how to filter data in Microsoft Excel using the Advanced Filter feature. This feature allows you to filter data based on the criteria that you specify. If you work with large data in Microsoft Excel, you know that you can filter it to view only the data that you want to see.

For example, You have survey data that has a country field and you need to filter by each country and create a presentation.

Know how to filter data using the Home Tab

You have a filter button in the excel home tab, which helps you to filter data in three steps.

1. Select the entire range of your data
2. Go to Home
3. Select Filter button

4. Click the cell A1 Dropdown icon – to open the context menu
5. Select Canada – you can select multiple Country
6. Press OK

Know how to filter data using Filter Toggle

You have another option to apply the filter to your data using the filter toggle button in the excel Data tab. You can use the filter toggle to quickly and easily filter your data by hiding the rows that do not meet your desired criteria. This can be incredibly helpful when you’re working with large data sets, as it allows you to focus on the data that is most relevant to you.

Please follow the below steps to use the Data Tab Filter toggle button to filter data

1. Select the entire range of your data
2. Go to Data
3. Select Filter button

4. Click the cell A1 Dropdown icon – to open the context menu
5. Select Canada – you can select either one country or multiple countries
6. Press OK

Know how to filter data in Table

Once you convert your data range to an excel table, you will get an option to filter your data.

Follow below steps to filter your data using Table

1. Select the entire data
2. Go to Insert Menu
3. Press Table – to open Create Table dialog box
4. Make sure your data range is in the Where is the data for your table? if not select the entire range
5. Select the checkbox My table has headers
6. Press OK

7. Click the cell A1 Dropdown icon – to open the context menu
8. Select Canada – you can select either one country or multiple countries
9. Press OK

Know how to filter data in Pivot Table

In this method first you have to create a Pivot table for your data.

Follow the below steps to add a Pivot Table in excel and then filter your data

1. Select the data you want to use to create the pivot table
2. Go to Insert Menu
3. Press Pivot Table – to open Pivot from table or range dialog box
4. Make sure your data range is in the Table/Range, if not select the entire range
5. Select the option Existing Worksheet
6. Type E1 in the Location input box
7. Press OK

You can see a blank pivot table is inserted in your excel sheet cell E1

1. Drag the Country field to the Rows area
2. Drag the Sales field to the Values area
3. Click the Dropdown icon in cell E1 – to open the context menu
4. Select Canada – you can select either one country or multiple countries
5. Press OK

Conclusions

The Filter in Excel allows you to narrow down a large dataset to only include the data that you want to see. This is done by creating a criteria that the data must meet in order to be included in the filter. Filter helps you slice and dice your data.

You used to receive a data file with number of fields, whicle creating presentation you may asked to provide separate slides for each country, category, and Top Sales Volume.

If you have any questions, please leave a comment below and I will get back to you as soon as possible.