Data Filters
Data Filters This may seem to be a very basic excel skills to some but if you don't know how to work with data filters, you'll need to develop this skill to stand out from the crowd.when you know how to use data filters you can sort, hide and search for crucial bits of information in a spreadsheet anytime you need to.The following steps for data filters in the way: 1) CLICK any where in your chart. 2) CLICK the chart filters button. 3) ON the values tab , check or uncheck the series of categories you want to show or hide. 4) CLICK apply. 5) IF you want to edit or rearrange the data in your series , click select data and then follow steps 2-4 in the next section. 1) What are the three types of filters in excel . Ans In excel you can create three kinds of filters: by values, by a format , or by criteria.But of these filters types is mutually exclusive for example you can filter by cell color or by a list of numbers , but not by both you can filter by icon or by a custom filter b...