You can also add filters in the form of Slicers to an Excel dashboard. Power users can interact with the dashboard and filter ...

but if you want to stay within Excel, the best way to do it is to create a dashboard for the most relevant data you want to highlight. What is an Excel dashboard, you may ask? Well, it's ...