Advanced Filter in Microsoft Excel

Advance Filter feature in Excel facilitates the easier way to extract records from dataset using complex criteria while saving lot of time. For instance, the criteria for filtering in our earlier Filter demonstration “How to Filter Records in Excel”  include “BAJAJ BOXER” as product and “MUSA” as Sale Rep. which took us up to eight steps[…]

Shares 0

How to Filter Records in Excel

Filter helps us to focus on a specific set of extracted (filtered) records that met certain criteria. This function can be accessed in three different ways (Home Menu, Data Menu and By Right click option). Let us take some examples for clear understanding. We can use filter to extract some information from the above data[…]

Shares 0