Learn how to use Excel's Subtotal feature to quickly add summarizing rows to your data.

If you need a monthly or yearly balance for revenue transactions in Microsoft Excel, you're in luck because both are easy! Here's how to find the totals you need.

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.

Outline Excel's Outline feature builds upon its Subtotal feature -- or subtotals you incorporate manually -- to add the ability to group and outline related values in up to eight levels of detail.

5. As a result, Excel not only subtotals all data by employee, but it also creates groups and inserts outline levels automatically for your entire data range, as pictured below. 6.

Learn how to use Excel's Subtotal feature to quickly add summarizing rows to your data.