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

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.

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

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.

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.

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