Ways to use the Slicer Tool within an Stand out 2010 Pivot Table

A really helpful feature in Stand out 2010 is the opportunity to make use of the new Slicer tool inside a Pivot Table to show a summary of filtered fields on screen. This is very handy if you’re presenting to someone who don’t use Pivot Tables very frequently because the slicer can show their email list of fields being an object plus the Table with no Field List being displayed. Additionally, it makes it simple to make use of Stand out like a presentation platform when addressing several clients, or perhaps a meeting rather of getting to turn to PowerPoint.

It’s a technique I’ve frequently used myself to provide alternative scenarios to someone inside a graphical, easily understood manner.

The Slicer tool is extremely versatile

Basically, a slicer is simply a graphical approach to filtering data. It’s accustomed to best advantage once the Ribbon is minimised – the default establishing Stand out 2013 – because this provides a obvious, unobstructed look at the information. This obvious look at the Slicer and also the facility to include Stand out 2010 Filter by altering their email list instantly makes mtss is a very effective tool for presenting along with a PowerPoint presentation it’s really a single integrated means to fix a launch, a customer pitch, an exercise session or perhaps a departmental meeting – the applications for applying Filters in Stand out 2010 and 2013 are endless.

While using Slicer Tools

Within this Pivot Table Tutorial we glance at ways to use the new tool. You have to first produce a Pivot Table within the normal way by clicking just one cell within the data that you would like to use the Pivot table to after which selecting Pivot Table in the Insert tab. Produce the Table using the needed fields displayed and filter them if required to show just the data you need to see. When you are pleased with the information being displayed, insert the Slicer in the contextual tab.

Filtering a Pivot Table using the Slicer

The Slicer can look on screen with a summary of all of the selected filtered fields visible. To change the vista, just click on among the fields and also the corresponding data is going to be displayed. If you’re presenting using a projector, the alterations can look instantly giving the crowd a genuine-time look at how that specific group of data would seem. If you want to show several field, holding lower the Ctrl key will help you to select non-adjacent fields in the slicer – if they’re alongside one another within the slicer dialog box, contain the shift key rather. To get rid of a slicer, click the Delete button around the Slicer to get rid of it.

Similarly to presenting scenarios, the Slicer can produce a quick “snapshot” of countless versions from the dataset presented diversely – it is only much faster to make use of and much more user-friendly. Additionally, it enables the presenter a really quick option to opening another PowerPoint presentation to be able to talk to a crowd, especially if utilizing a Pivot Table Template in which the ribbon is minimised and also the different home windows accustomed to illustrate the variations instead of while using field list.

You aren’t limited to one Slicer

Just when you are not limited to one slicer, you have many formatting and layout options with every slicer you’ve open. Choosing the slicer opens a contextual Slicer Tools tab having a ribbon attached which contains tools specific towards the slicer itself. Came from here you are able to change the amount of posts the slicer displays, the color plan put on it, the peak and width, not only from the slicer but additionally from the buttons, the alignment and so forth.

In case, you were contemplating on gathering requisite knowledge on pivot table training, you should look forward to joining COMAT. The website has been popular for providing to your specific needs and requirements in the best manner possible to suit your needs.