Filter table in Excel 2016

Hi

I have a table of data. The table has multiple columns with name, grade, date, location

As Excel 2016 does not have the filter function I am trying to find another way of filtering. I know the filter options to select filters but i would prefer if excel can display rows of data based on a search criteria.

For an example I want the table to only show a specific grade, lets say A (which I may change to B or C). I would like all entries matching what I have entered as the grade to show those rows that match.

Can this be done. Its like a pivot table where I filter by grades and have the values appear in a table below, and as i change the filter the data shows based on the filtered value. I dont want to use Pivot table however as when filtered I would like to be able to have additional free text columns for returned rows.

Hope this makes sense.

Thanks

Tams

OMG Diana, thank you. Im gonna give that a go. Thanks in advance.

OMG Diana, I love you. Do you know if I can place the slicer on another sheet?

Done! Thanks for letting me know

Thanks Tanasedn for confirming. Much appreciated