A really helpful feature in Excel 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 some group of people that 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 Excel like a presentation platform when addressing a group of 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 some group of individuals 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 Excel 2013 – because this provides a obvious, unobstructed look at the information. This obvious look at the Slicer and also the facility to include Excel 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 Excel 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.
When you’re completed with the Slicer, choosing the border and hitting Delete will take it off directly from the screen and returns the crowd towards the standard Pivot Table view which was displayed formerly. When the data point is pivoted again to exhibit another see the Slicer tool may be used again to repeat the options for that audience.
In this manner you are able to present an intricate selection of situations easily and rapidly, and they may be displayed in a fashion that is engaging and simple to understand. So that as this selection is additional towards the existing “Let’s Say” data analysis tools it provides an unbeatable edge to Excel and puts this 2010 version in pole position within the spreadsheet race.
Than to request your friends on developing the pivot table for your research work, you could do it by self, provided you attend the pivot table training and also learn all the details pertaining to this skill.