Filters, one of the biggest issues of our company of sharepoint

hello Skoets 

Depending on the content in your excel file (mostly list vs heavy formulas) you might want to consider converting to a custom SharePoint list. You can still do some calculated fields, but you would not be able to do complex formulas.

These are great for allowing multiple users to access and make updates while working off "one version of the truth" which is much better than individual copies of excel files.

You can create as many custom views of the list to pre-filter, group and sort (even sub-total by groups). And even after all that, you can sort and filter by the column headings.