Almost every month, I suggest the Subtotal feature to a reader. It's an easy-to-use feature that summarizes data by groups. You define the group and the summarizing function; Excel does the rest ...

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows. When you try to copy the subtotals by ...

Accept defaults ("Microsoft Office Excel list or database" and "PivotTable") and click Next. You can come back later and choose PivotChart report to make pretty charts for the PHBs.

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.

The subtotal function in Excel is a handy way to calculate smaller amounts, separate from the final total. It's relatively easy to use in a spreadsheet, and it allows you to organize your data. The ...

Click the Data tab. Click Subtotal in the Outline group. In Excel 2003, Subtotals is on the Data menu. In the resulting dialog, choose Count from the Function dropdown.

Chart the Summary Data Click "Insert" in Excel's ribbon. Click "Pie" in the Charts group, and click one of the "2D Pie Chart" options to create a blank chart. Right-click the chart.

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