1. Computing

Excel Subtotal Tutorials

Using Excel's Subtotal Feature to Find Specific Information in a Database

By

Excel's Subtotal feature helps you draw specific information from one or more subsections of a database or list of data.

In addition to finding the subtotal for selected rows of data, you can also use the Subtotal feature to find, among other things, the average value for the selected range of data, the largest and smallest values, or the total number of rows of data included in the range.

The step by step tutorials below include examples of how to find use Excel's Subtotal feature to find this information.

 

Inserting Subtotals and Totals into a Database

Excel Subtotal Feature
© Ted French

Use Excel's subtotal feature to insert subtotals into a database. The tutorial includes a step by step example of how to use the Subtotal feature in Excel.

Find Average Values with Excel's Subtotal Feature

Excel Subtotal Feature
© Ted French

Use Excel's subtotal feature to find the average value for each subsection of a database. The tutorial includes a step by step example of how to find the average value for each subsection using the Subtotal feature.

Find the Largest Values with Excel's Subtotal Feature

Excel Subtotal Feature
Excel Subtotal Feature

Use Excel's subtotal feature to find the largest values for each subsection of a database. The tutorial includes a step by step example of how to find the largest value for each subsection value using the Subtotal feature.

Find the Smallest Values with Excel's Subtotal Feature

Excel Subtotal Feature
Excel Subtotal Feature

Use Excel's subtotal feature to find the smallest values for each subsection of a database. The tutorial includes a step by step example of how to find the smallest value for each subsection value using the Subtotal feature.

Data for Excel SubTotal Tutorials

Excel Pivot Table Tutorial
Excel Subtotal Feature

This article gives instructions for copying the sample data into an Excel worksheet. The data accompanies the Step by Step Excel SUBTOTAL Tutorials listed above.

Top Related Searches
  • step tutorials
  • subtotal
  • ted
  • ©2014 About.com. All rights reserved.