IS THERE A QUICK ANALYSIS TOOL IN EXCEL 2010 HOW TO
To follow using our example, download How to Use Slicers in Excelįor this exercise, begin by creating a PivotTable from your raw data with the set of fields you wish to analyze. We will use slicers to narrow our view and filter the table without having to click on tiny filter arrows and select from cumbersome drop-down lists. The number of team members makes it difficult to compare performance among them. Our example data includes monthly totals for a large sales team. This article will demonstrate how to create a slicer in both 20 versions of Excel. Something like a cross between a button and a filter, Slicers have become a prized tool for analyzing large data sets in dashboards and reports.
This useful feature is excellent for viewing and comparing varied combinations of your data with a simple click. Categories: Excel®, PivotTables Tags: excel slicers 2010, how to use slicers in excel, slicers in excel 2013Įxcel’s Slicer Filter was added in Excel 2010 and enhanced in Excel 2013.