Question
How to insert a slicer in Excel?
Answer
A slicer is the same thing as adding a Report Filter, however, the slicer is a more interactive way to see the changes being made to the chart.
To do this go to the PivotTable Analyze tab > Filter > Insert Slicer. A list will then appear with all of the fields you have on the Pivot Table Field List. Select the item you would like to create into a slicer and click OK.
To select more than one item hold down the CTRL key and click the countries you would like to add.
Just like most areas in Microsoft Office there are options to format this function to appear differently. When you insert a slicer the Slicer Tools tab will appear giving you a few options to format the slicer.
You can resize the slicer by clicking and dragging on the corners of the box. To format the color of the slicer go to the Options tab, and in the Slicer Styles tab, click on the More button (drop down arrow). There you will see all of the options for formatting the slicer.
For more information about Pivot Tables in Excel, please view the full tutorial from the CTL here: Excel Part 4
If you need further assistance, please click the CTL Support Request button on this page.