Are you interested in alternatives to filtering in Excel?

Welcome back to the ‘Stop Filtering In Excel’ Series!

Download Your Excel Free Cheatsheet

In video 2, we explore a cool ‘one-click’ alternative to using Excel filters. The best thing about this technique: it’s visual! It looks great and people love interacting with it. My Excel consultancy customers love it and I’m sure you will too …

CLICK HERE TO WATCH THE VIDEO

The technique: Excel slicers. If you’ve never used them before, you’re in for a treat. So make sure you download the Excel slicer download file, and work along with me.

CLICK HERE FOR THE DOWNLOAD FILES

The bad news: Excel slicers work through a pivot table. So, we cannot access the power of slicers without inserting a pivot table into the file! But don’t worry, the pivot table is relatively easy to configure, and I do it step-by-step in this video – make sure you work along with me.

In the video, I use Excel slicers to answer a typical data analysis question, in this case about football trading systems. To make absolutely sure, I test the mechanism by getting the same answer not one, not two, but three (!) different ways – using Excel slicers, using the DSUM formula from the previous video, and using conventional Excel filtering (it’s ok for testing purposes … only!)

I would love to hear what you think of Excel slicers – let me know your thoughts in the YouTube comments and I hope you can integrate this powerful technique into your Excel practice! What else would you like me to cover in the Stop Filtering In Excel series?

Download Your Excel Free Cheatsheet