Slicers are the new visual filter in Excel 2010 Pivot Tables. Learn how to make them look good. Slice, Dice and Present your data using tips from Podcast #1241.
"Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
"Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
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, might want to create some filters, that we can do some ad-hoc reporting.
Back here, on here options, on there. Insert Slicer.
And choose what slicers I want region, product, customer. Click [ OK ].
BAM!
They 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, all right! But hey!
A couple of clicks here, we can change it.
So, region nice, short, three items.
Let's make it be three columns 1, 2, 3.
Make a little bit wider.
And then certainly, not as tall as it starts out being so, make it sure.
I'm also a big fan of changing the color of each slicer.
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.
Actually fits right there in that current width.
Make a little bit shorter.
And then customer.
Now, customer is a big long list.
Customers have big long list of items, that looks really good as a very long vertical slices.
Let's just change the color of that one.
So, we come back to the slicer option.
Crisp styles and choose a different color.
Alright! So.
Just a little bit of work on your part, can make the slicers look a lot better.
You can arrange them, where they fit and a better arrangement than the tiled arrangement, that we get it.
It's ironic the PowerPivot people, actually make the slicers look pretty good.
When they add them to the pivot tables, one of the things that power pivot does really well.
Which is that, people on the Excel team would kind of steal that logic and add it to the regular Excel.
So, where we didn't have to reformat the slicers every...
I want to thank you for stopping by.
Will see you next time for another netcast, from MrExcel.
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, might want to create some filters, that we can do some ad-hoc reporting.
Back here, on here options, on there. Insert Slicer.
And choose what slicers I want region, product, customer. Click [ OK ].
BAM!
They 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, all right! But hey!
A couple of clicks here, we can change it.
So, region nice, short, three items.
Let's make it be three columns 1, 2, 3.
Make a little bit wider.
And then certainly, not as tall as it starts out being so, make it sure.
I'm also a big fan of changing the color of each slicer.
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.
Actually fits right there in that current width.
Make a little bit shorter.
And then customer.
Now, customer is a big long list.
Customers have big long list of items, that looks really good as a very long vertical slices.
Let's just change the color of that one.
So, we come back to the slicer option.
Crisp styles and choose a different color.
Alright! So.
Just a little bit of work on your part, can make the slicers look a lot better.
You can arrange them, where they fit and a better arrangement than the tiled arrangement, that we get it.
It's ironic the PowerPivot people, actually make the slicers look pretty good.
When they add them to the pivot tables, one of the things that power pivot does really well.
Which is that, people on the Excel team would kind of steal that logic and add it to the regular Excel.
So, where we didn't have to reformat the slicers every...
I want to thank you for stopping by.
Will see you next time for another netcast, from MrExcel.
