Join Dennis Taylor for an in-depth discussion in this video Enhancing table filtering with slicers, part of Excel Tips Weekly.
- View Offline
- 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.…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.