Apr 16, 2015 In both Excel 2010 and Excel 2013, you can add a Slicer to your Pivot Table. In order to do this, first, create your Pivot Table by selecting the. The Pivot Table invites data exploration and analysis: “slicing and dicing” large amounts of In Excel 2007 a range of data that has the characteristics above can be specifically designated as allow you to easily add (or remove) that column. Jan 26, 2012 In Excel 2007, you would have had to create separate category filters for In the Insert Slicers dialog box, select the Category and Year field.
Jun 7, 2012 Whether you.re training users or creating custom applications, slicers (new to Excel 2010) are an easy way to filter data in multiple ways without. Article about using Pivottable slicers in Excel 2010: COnfiguring slicers. But since you can only edit custom styles, the first step is to add a custom s