Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the importance of filter in MS Excel?

user-image
Question ajoutée par abdur rasheed , Network Administrator , Warid Telecom (Al-Khalej Telecom)
Date de publication: 2013/07/18
Roy Mathew
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?