diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


PowerPivot and Slicers for Microsoft Excel 2010 [Video]

PowerPivot is a free add-in for Excel that can link multiple spreadsheets or even link to databases. That means you can work with millions–emphasis on the “s”–of lines of data.

Excel also has another tool called “Slicers” to help you slice through data.

Slicers are visual controls that allow you to quickly and easily filter your data in an interactive way. They float above the grid, like charts and shapes.

Here’s an example of the same slicer in three different states. You can select one, all, or some countries. A slicer acts like a report filter, so you can hook it up to a PivotTable, PivotChart, or CUBE function to create an interactive report.

Slicers in Excel 2010

Why Slicers?

For the first version of slicers, the Excel team wanted to enable you to:

  • See what you’re doing at all times
  • Easily interact with your data
  • Filter multiple PivotTables, PivotCharts, or CUBE functions together
  • Put together dashingly handsome reports

Watch this video to learn more about PowePivot and Slicers wiht Doug Thomas:

Share This Story, Choose Your Platform!

Get Latest News

Subscribe to Digital News Hub

Get our daily newsletter about the latest news in the industry.
First Name
Last Name
Email address
Secure and Spam free...