You poured data into a pivot table. Now what? Make them smarter. Here's how to use Summarizing Data and Calculated Fields in order to get a different perspective on your marketing data through the ...

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

Automatic date and time grouping: Excel 2016 automatically groups your date- and time-related fields (year, quarter, month) in your PivotTable. Once the fields are grouped together, you can drag the ...

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

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.

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

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.