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

Do you want to group data by category? Use a PivotTable. Interested in comparing results by person, by quarter, or by category? Use a PivotTable. Need to answer questions that start with “How ...

How to automatically group data in a pivot table If you'd like to break your data into groups based on years or want to group it by date, you can do this automatically.

When analyzing grouped data, bypass complex functions and use a Microsoft Excel PivotTable.

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.

Then, before you use the data set to create a PivotTable, make sure each column is assigned the correct number format (text, accounting, or short date).

Summarizing data is a common task in Excel, and there's usually more than one way to do so. Susan Harkins explains three ways to return averages for multiple groups.

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