Excel 2016 Data and List Management

Lesson 3 – Working with Outlines

Excel 2016

Steps

Practice Data

2. Select a cell in the column

Click cell D6

containing the entries you want to use for grouping. The cell is selected. 3. Select the desired sort order from the buttons in the Sort & Filter group. 4. Select the Subtotal button in the Outline group. The Subtotal dialog box opens. 5. Select the At each change in list. A list of column names is displayed. 6. Select the name of the column you used to sort the list. The column name appears in the At each change in box. 7. Select the Use function list. A list of functions is displayed. 9. Select the first column for which you want to calculate subtotals in the Add subtotal to list box. A tick appears in the box beside the selected column name. 10. Select or deselect additional columns, as desired. The columns are selected or deselected accordingly. The list is sorted based on the entries in the selected column. 8. Select the desired function. The function appears in the Use function box.

Click Sort A to Z

Click

Click At each change in

Click Department

Click Use function

Click Sum

Click

Salary to select it

Click

Raise to select it,

if necessary

11. Select or deselect subtotal options, as desired. The options are selected or deselected accordingly.

Follow the instructions shown below the table before continuing to the next step

Page 80

OFFICEPRO, Inc.