Enhancing table filtering with slicers

- When you work with large amounts of data…there's no question that filtering is a great tool…for seeing just what you want to see.…But one of its drawbacks is that you're not always reminded…of what you are not seeing.…In Excel 2010 a new feature's introduced,…but it was only available in pivot tables,…it's called a Slicer.…It's now available if you've got data…that's been converted into a table.…Now not everybody's familiar with the table concept,…but at any time you're working with lists of data,…like this with no embedded subtotals,…no empty rows, you can convert the data into a table.…

You can actually do it four ways.…Two quick keystroke shortcuts are ctrl + t, think of table,…ctrl + l, possibly you're thinking of list.…You can also get to the feature on the HOME tab,…Format as Table, or possibly on the INSERT tab, Table.…And most cases Excel immediately figures out…the extent of your data,…click OK and the data has been converted into a table.…Now filter arrows are present and if we wanted to see…just certain departments here we could do that.…