Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

For those who do accounting, you probably know the PivotTable is a specialized Excel tool for statistics and data processing in reports.

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

Excel's PivotTable feature is a fantastic option for data analysis, allowing users to consolidate and analyze data from various sources in a single, ...

To use the PivotTable after you have created it, follow the steps in this procedure. For more information about using PivotTables, see the Microsoft Excel documentation. [!NOTE] When you create a real ...

Use Excel PivotTables to quickly analyze grades Want to quickly sort the data in your Excel gradebook by category, such as section number or teaching assistant’s name? PivotTables let you view this ...

Excel 2010 KPI tutorial 6: Conditional format icons Applied Excel: Building a traffic light KPI dashboard (2008) Build a dashboard with Excel 2010 Sparklines Presenting financial figures with Excel: ...

Have you found this content useful? Use the button above to save it to your profile. PivotTables aren't just for show. Simon Hurst shows how some subtle enhancements in Excel 2007 can help you managed ...