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.
