As discussed in a previous post, Excel Pivot Tables are powerful tools for analyzing and reporting on data from your accounting software package, and other business data sources.

With Office 2010, Excel has an added feature that takes Pivot Tables a step further: the Slicer – which allows you to slice and dice an existing Pivot table through new dimensions.

For example, here’s a simple Pivot table summarizing sales by customer by year:

Sales Pivot

But what if we wanted to further analyze these sales numbers, slicing them by different salespeople and product categories, for example? Enter the Slicer:

“Sliced” Pivot

In this example we’re still looking at sales by customer by year, but we’ve sliced it for sales by 2 salespeople only, and for just the Seafood and Bowls product categories.

Anyone else used this (or even knew it existed)?