How to Filter Data Fast - Data Analysis in Excel

HR, ADMIN, PROCUREMENT, SMALL COMPANY

Quick data filter steps to help you categorize the focus groups. In this case, the example is to purchase company shirts for 126 employees based on height categorized size - S, M, L, XL, etc.

End of the filter, we will know estimated 9 of Small, 59 of M, 31, L and 27 XL required. Of course, we need finalize and tweak the numbers after the filtering to make the best decision.

Cheers.

PIVOT TABLE
COUNT / GROUP / ADJUST VALUE