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

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.

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.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.