Faysal Easy Excel

Slicer Caption: Slicer Caption is an option to change the Slicer name. By default Slicer took the field's name as Slicer name. For example if you use the command Insert | Slicer then it will show a list with all the present field names and you have to choose which field you want as Slicer. After choosing a field by Marking, Slicer will insert with that field name. Image 1: Slicer Caption If you want to change the Slicer name, just Click the Slicer to activate it. Now go to Options menu and edit the Slicer Caption as "Area Wise" from Slicer group and press Enter. Slicer Settings: Slicer Settings allow you to Show or Hide the Slicer name by marking or no marking the Display header option. You can change the Caption from here too. Image 2: Slicer Settings By choosing the Ascending (A to Z) radio button you can sort the Slicer buttons from A to Z or Descending (Z to A) for Z to A. You can use the Use Custom Lists when sorting option for custom arranging ...

Step 1:  Select the Slicer and click on Options. Step 2:  From Slicer Style group select any Dark or Light style from preview list. Image 1: Formatting Slicer

To remove slicer Simply you can remove it by just selecting it and press Delete from keyboard.

For both things Slicer adding process is same due to these two things follow the same table. Step 1: Put the cursor anywhere in a PivotTable reporting area. Step 2: Then Click on Insert menu and Click on Slicer. Or you can simply Right Click on the Field name which you want as Slicer from PivotTable Fields List. Step 3: This will add the Year Slicer into your workbook. Resize it and move it by mouse dragging to a suitable location. Image 1: Slicer added

Assume that, based on below data table you wish to insert a Slicer Area. Image 1: Data Table Step 1: First of all select a table and click on Insert menu and then Click on Table. Or simply press Ctrl+T after selecting your data table. Step 2: Now you will see a dialog box named Create Table and note that, the table range is automatically selected entire table. If you want to do a custom range selection then just click the Red Upper-Left Directed Arrow and select the range and press the Enter. Step 3: After clicking the Ok your data table will converted as Table, which has a default name Table 1. Step 4: Place the cursor anywhere in the Table 1. And click on Insert menu and then click Slicer from Filters group. Image 1: Selecting Slicer Step 5:  Now you will get a dialog box named Insert Slicer. Just mark the fields which you want as Slicer and click on OK button. I would select Region. You can add 2 or more Slicer from 1 table. Image 2: Adding a Field a...

Slicer is nothing but a new filter items. It shows like buttons rather than a drop down list like Filter. In dynamic report or dashboard, it is good to use the Slicer for giving an attractive look to your reports. With the help of Slicer, a viewer can easily check your reports and in very short time, he will took his information from your reports. Slicer added in Excel from Excel 2010. You can add Slicer through a Table or PivotTable. Image 1: Slicer By clicking the Blue button under Color Slicer, you will only see the Blue color product's sales data in the dashboard. And by this way you can view other report as well. Image 2: How Slicer works In where you can add Slicer? You can add Slicer for generally 3 types of report. These are: Table PivotTable PivotChart