Slicers as an alternative to conditional drop downs

Beginning with Excel 2013 for Windows, we can use Slicers to filter table data. In this post, we'll explore how to use Slicers as a relatively easy alternative to conditional drop-downs.

There are many benefits to using the Slicers approach, including, Slicers automatically create unique buttons from a column with duplicate values, automatically include scroll bars if needed, and automatically sort the buttons.