Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the importance of filter in MS Excel?

user-image
Question added by abdur rasheed , Network Administrator , Warid Telecom (Al-Khalej Telecom)
Date Posted: 2013/07/18
Roy Mathew
by Roy Mathew , Assistant Finance Executive , Al Hadith Trading LLC

The excel feature "filter" is a very important feature as it saves time & reduces workload by many times especially for those who use excel all day.
It is used everyday mainly for analysis work.
Filters are used to find all records matching a certain criteria at one place.
There are different types of filter in Excel such as number filter, text filter, begins with, ends with, contains, display top10 etc....
Example: if you want to examine all payments above AED50,000, then you can use the number filter "greater than".
Excel will then display only those transactions and saves time in finding each transaction manually.
The benefits of filters (saves time & reduces workload) increase exponentially when there are more than one or two criteria if you have50,000 transactions items and suppose the type of transaction that you look for a only5 to10 in number, instead of seraching manually you can use "Filters".
Another option other than filter is to "sort" in excel , but when there are more than2 conditions I think filter does a better job saving time.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.