Slicers are the new visual filter in Excel 2010 pivot tables. Learn how to make them look good.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel (laughs) Excel In Depth chapter 24 - Formatting Slicers!
Alright, slicers, brand new in Excel 2010, great way to visually filter a Pivot table.
I have a tiny little Pivot table here, but I want to create some filters, so we can do some ad hoc reporting.
Back here under Options I'll do Insert Slicer, and choose what slicers I want, Region, Product, Customer, click OK, and BAM.
They always show up right in the middle of screen, they're always tiled, they're always one column, and they're always ugly blue, hate that!
Alright but hey, a couple clicks here, we can change this, so region, nice, short, three items, let's make it be three columns, make a little bit wider, and then certainly not as tall as it starts out being, so we make that short.
And I'm also a big fan of changing the color of each slicers, that way they look different.
So here under slicers we have the Quick Styles, just choose a different color, doesn't matter.
Product, same thing, three products, nice, short, let's make those be three columns, it actually fits right there in that current width, we need to make a little bit shorter.
And then Customer, now Customer is a big long list of items, that looks really good as a very long vertical slices, let's just change the color, so we come back to Slicer Options, Quick Styles, and choose a different color.
It's just a little bit of work on your part can make the slicers look a lot better, you can arrange them so that way they fit in a better arrangement than the tiled arrangement that we get.
It's ironic, the PowerPivot people actually make the slicers look pretty good when they add them to the Pivot table it's one of the things that PowerPivot does really well.
I wish that people on the Excel team would kind of steal that logic and add it to the regular Excel, so what we didn't have to reformat the slicers every single time.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Excel (laughs) Excel In Depth chapter 24 - Formatting Slicers!
Alright, slicers, brand new in Excel 2010, great way to visually filter a Pivot table.
I have a tiny little Pivot table here, but I want to create some filters, so we can do some ad hoc reporting.
Back here under Options I'll do Insert Slicer, and choose what slicers I want, Region, Product, Customer, click OK, and BAM.
They always show up right in the middle of screen, they're always tiled, they're always one column, and they're always ugly blue, hate that!
Alright but hey, a couple clicks here, we can change this, so region, nice, short, three items, let's make it be three columns, make a little bit wider, and then certainly not as tall as it starts out being, so we make that short.
And I'm also a big fan of changing the color of each slicers, that way they look different.
So here under slicers we have the Quick Styles, just choose a different color, doesn't matter.
Product, same thing, three products, nice, short, let's make those be three columns, it actually fits right there in that current width, we need to make a little bit shorter.
And then Customer, now Customer is a big long list of items, that looks really good as a very long vertical slices, let's just change the color, so we come back to Slicer Options, Quick Styles, and choose a different color.
It's just a little bit of work on your part can make the slicers look a lot better, you can arrange them so that way they fit in a better arrangement than the tiled arrangement that we get.
It's ironic, the PowerPivot people actually make the slicers look pretty good when they add them to the Pivot table it's one of the things that PowerPivot does really well.
I wish that people on the Excel team would kind of steal that logic and add it to the regular Excel, so what we didn't have to reformat the slicers every single time.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
