When working with mountains of Excel data, you ultimately need to find information that meets certain criteria. Whether you want to limit categories or compare specific sales, you need to learn how to filter in Excel.
Filtering is one of the simpler tasks you can learn in Excel, and it can save a lot of time, as well. Check out some of the steps below to get started: Filtering
1. Click a cell in a dataset.
2. Go to the tab Data and find the group Sort and filter . Now click on Filter . You should now see arrows appear at the top of each column.
3. Select the arrow next to the title you want to filter. Once the menu opens, click Select All to clear the boxes, then click one of the options. In our example, we chose the league title and then selected the US.
4. Click OK and now you will only see the US sales numbers.
In our example you can go even further and the sales numbers per quarter. Just follow the same steps as above. To filter your cells, go back to the Data tab and find the Sort & Filter group. Now click on clear and all your data should return like the image below.
What else can I learn?
Filtering is a skill that often becomes useful after you learn a few other basic skills in Excel. If you're ready to hone your skills, a little training can go a long way. You can dig into useful formulas and functions and move on to trickier topics like pivot tables and VBA. We are now highlighting a bundle on Tech Deals that can help you with all of the above.
It's called the Professional Microsoft Excel Certification Training Bundle and it consists of eight modules and an impressive 45 hours of content. You will learn all the basics and start exploring data models and Power Query. It is one of the easiest ways to go from Excel zero to hero.
The eight modules have a combined retail value of $ 1,600, but you can get started now for $ 39 and save 97 %. More than 4,000 people have already signed up to hone their skills. You can see what matters through the widget below.
$ 39 .00
The Professional Microsoft Excel Certification Training Bundle
Save $ 1561  .00
Save $ 1561 .00 $ 39 .00