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

It’s easy to display details in a PivotTable group if you know how to expand the group in Microsoft Excel.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

Learn how to create Excel Pivot Tables in this comprehensive beginner's guide taking you through the process step-by-step. Spreadsheets can ...

Q: How do I add a percentage-of-total column in a PivotTable in Excel 2010? A: The October 2011 JofA Technology Q&A column (page 76) included an item titled “ Make a Difference With PivotTables,” ...

After selecting your chart type, Excel will generate a PivotChart that is linked to your PivotTable. This means any changes you make to the PivotTable will automatically update the PivotChart.

This month’s column introduces Excel’s GROUPBY function as a PivotTable alternative.

Never work on the original spreadsheet. Instead copy it. This way, if you make a mistake you will be able to go back to the original. Second, don’t delete data because you may need it in the future.