To turn your big data set into a PivotTable, select any cell in the range, and in the Insert tab on the ribbon, click the top ...

If you're still manually sifting through massive spreadsheets or relying on clunky, old-school sorting tools, you're doing it the hard way. Excel has the powerful FILTER function, a built-in solution ...