Excel 2016 Data and List Management

Excel 2016

Lesson 3 – Working with Outlines

NOTE You can add more than one type of subtotal to each group. First, create the subtotals using the first function (such as SUM). Then, reopen the Subtotal dialog box, select the second function (such as AVERAGE) and choose the columns to which you want to add the new subtotals, then deselect the Replace current subtotals option. The new subtotals are inserted in a new row below each group and a further level appears in the outline.



P ROCEDURES

1. Select the Data tab. 2. Select a cell in the column containing the entries you want to use for grouping. 3. Select the desired sort order from the buttons in the Sort & Filter group: or .

4. Select

in the Outline group.

5. Select the At each change in list. 6. Select the name of the column you used to sort the list. 7. Select the Use function list. 8. Select the desired function. 9. Select the column for which you want to calculate subtotals in the Add subtotal to list box.

10. Select or deselect additional columns, as desired. 11. Select or deselect subtotal options, as desired. 12. Select OK .



S TEP - BY -S TEP

Create subtotals in a list.

Display the Employees worksheet.

Steps

Practice Data

1. Select the Data tab.

Click Data

The Data tab is displayed.

OFFICEPRO, Inc.

Page 79