Join Dennis Taylor for an in-depth discussion in this video Use slicers and charts together for dynamic presentations, part of Excel Tips Weekly.
- [Voiceover] Starting in Excel 2010,…there's a new feature called a Slicer,…and in Excel 2010 it was only available for pivot tables,…but starting in Excel 2013, it's available…for any data that's been converted to a table.…In this worksheet I've got a list in columns A, B and C,…and the same data has been reworked a bit.…It's also in columns E, F and G.…Now we could work with either one of these lists.…I'm going to work with the list on the right.…Here's what I'd like to be able to do:…I'd like to have a chart of this,…and I want it to be somewhat interactive in the sense that…as I'm meeting with some HR professionals…we'll be talking about some staffing issues,…and we want to have the ability to use Slicers…as we make our presentation.…
One of the big advantages of Slicers is that…we have a clear reminder at all times…not only what is being shown, but what is not being shown.…But we can't use Slicers with this list just yet…because it's not a table.…You can convert a list into a table simply by…doing one of four things:…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
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.