Excel 2016 Data and List Management

Excel 2016

Lesson 3 – Working with Outlines

Steps

Practice Data

12. Select OK .

Click

The Subtotal dialog box closes, subtotals appear in new inserted rows below each group and outlining is applied to the list.

Ensure that the following options are set to the default settings:

Replace current subtotals - selected Page break between groups - deselected Summary below data - selected

Return to the table and continue to step 12.

Practice the Concept: Scroll to the bottom of the list to view the Grand Total row. Widen column F, if necessary, to view the total. Scroll back to the top of the worksheet.

Select the level 2 outline level button to collapse the outline details. Notice that only the totals for each group and the grand total are displayed. Click the Show Detail group level button next to row 27 to expand the Production group. Redisplay all the details by selecting the level 3 outline level button.

Select any cell in the list. Click the Subtotal button in the Outline group and set the following options:

At each change in - Department Use function - Average Add Subtotal to - Salary only (deselect Raise) Replace current subtotals - deselect Page break between groups - deselect

Click OK to apply the additional subtotals, then scroll the worksheet to view the results. Notice that the outline now has 4 levels. Collapse and expand outline levels as desired to observe the different views available. Click the level 4 outline level button to redisplay all levels.

OFFICEPRO, Inc.

Page 81