Claim this complimentary eBook worth $50 for free, before the offer ends on Sep 16.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends. If you're new to pivot tables, this guide will get you ...

Unlock advanced data analysis in Excel with Power Pivot. Overcome PivotTable limitations and enhance your data insights effortlessly.

PowerPivot is Microsoft's new self-service business intelligence (BI) product that seeks to make peace between IT and Excel users. PowerPivot is a component of SQL Server 2008 R2 that works with ...

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Slicers are an Excel feature designed by the Analysis Services team for use with PowerPivot models, but they can, in fact, be used with non-PowerPivot PivotTables as well.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

An curved arrow pointing right. Here's how to create pivot charts in Excel to quickly and easily analyze large data sets. Produced by Sara Silverstein Follow BI Video: On Facebook More from Tech ...