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.
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: