If the user wants to find a subtotal of the values that belong in a particular group, the groups must be identified by a label in one of the columns. Finding subtotals is a two-step process. First, the table is sorted by that column to bring all the rows in each group together. Next, the subtotal feature is applied. In Excel 2007, the subtotal option is found on the Data tab, in the Outline group. A dialog box allows the user to choose the columns to subtotal and the columns that contain the labels of the groups. A subtotal is inserted below the last row for each group, as shown in Figure 6.17.
In a panel at the left of the screen are lines and symbols that indicate the level of detail that is displayed. By clicking on the boxes with minus signs, the rows containing the data can be hidden, leaving the subtotals or grand total, as shown in Figure 6.18 and Figure 6.19. This feature allows a manager to view summary data very quickly without the visual clutter of the details.
- 819 reads
