Life’s a Slice(r) with Excel 2010

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)?

One Response to Life’s a Slice(r) with Excel 2010

  1. Brad Bowyer says:

    This look like the same feature as existing pivot tables – with a data selection in the page area. Looks easier make multi selection however.

Follow

Get every new post delivered to your Inbox.

Join 103 other followers

%d bloggers like this: