If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting.

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

When working with multiple sheets in an Excel workbook, you may need to reference data from one sheet to another for calculations, analysis, or to keep your workbook organized.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.