ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is the importance of filter in MS Excel?

user-image
تم إضافة السؤال من قبل abdur rasheed , Network Administrator , Warid Telecom (Al-Khalej Telecom)
تاريخ النشر: 2013/07/18
Roy Mathew
من قبل 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.

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟