data list

There can sometimes be situations when it is necessary to add more than one summary function to a list. For example, you may want to present both subtotals and averages for the groups within a data list. To display summary functions follow these ... steps: Sort the data list on the field or fields by which the data should be grouped. Position the active cell within the data list. Choose Data | Subtotals. The Subtotal dialog box will appear. Specify options for the first subtotal. Choose OK. Choose Data | Subtotals. The Subtotal dialog box will appear again. Specify options for the second subtotal ... (view more)

When automatic subtotals are inserted, Excel outlines the list by grouping detail rows with each associate subtotal row, and grouping subtotal rows with the grand total row. To insert subtotals and grand totals in a data list, follow the ... instructions below: Sort the data list on the field or fields by which the data should be grouped. Position the active cell within the data list. Select Data | Subtotals. The Subtotal dialog box appears. Select a field by which to group from the At each change in drop-down list. Select a calculation function from the Use function drop-down list. Select the ... (view more)

A single data list may contain records that fall into several categories or groups. Depending on the size of the data list, it may be difficult to focus on all of the records that belong to a specific group. Data filtering in MS Excel enables the ... user to work with a subset of data within the data list. When a filter is created, only the records that contain the values specified are displayed. Other records in the data list are hidden temporarily. AutoFilter is an automated filtering tool included in Excel. When AutoFilter is applied to a data list, the column headings change to drop-down list ... (view more)