Excel 2010 – Slicer

Microsoft Excel 2010 delivers a new feature called slicer; it allows you to slice-and-dice your pivot table.  In the older versions of Excel, if you want to use pivot table to do an income analysis for BC, Ontario and Quebec; and include disability insurance and long term care products; then you would use report filter to select corresponding items in province and product type.  But report filter does not give you a good visualization, where slicers show you what you have chosen.

Create a slicer in an existing PivotTable – it cannot be easier.

• Click anywhere in the PivotTable report for which you want to create a slicer.  This displays the PivotTable Tools, adding an Options and a Design tab on the Ribbon.
• On the Options tab, in the Sort & Filter group, click Insert Slicer.

• In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.

• Click OK, then you can use the slicers to choose your provinces and product types.

You know what have been included and what have not been in your pivot table.

Andrew Chan is the owner and founder of ALG Inc.

We help you to make better and faster decisions!