Whether you're using a big, formatted table of data in a worksheet or a full-on pivot table that's equally stuffed, you can filter the data down pretty quickly and easily with a Slicer.
Pivot Tables are meant to simplify (and partially automate) the ways you can organize and interpret the various data points in your spreadsheets. Think of it as a way to make either Excel or Sheets ...