Excel 2016 Tips and Tricks

Lesson – Working with Tables

Excel 2016



S TEP - BY -S TEP Filter data using number filters.

Steps

Practice Data

1. Select the desired Filter arrow. The Filter menu opens.

Click Sales

2. Point to Number Filters .

Point to Number Filters

The Number Filters submenu opens.

3. Select the desired number filter option. The Custom AutoFilter dialog box opens with the desired filter pre- selected. 4. Enter the desired number in the box to the right of the selected number filter. The number appears in the box. 5. Enter a second filter criteria in the dialog box, if desired. The desired criteria appear in the second row of boxes.

Click Greater Than

Type 1000

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

6. Select the OK button.

Click

The Custom AutoFilter dialog box closes and the table data is filtered.

Select the left-hand list in the second row of boxes in the dialog box. Scroll as necessary and select is less than or equal to . Click in the right-hand box in the second row of boxes and type 2500 . Select the And option between the two rows of boxes, if necessary.

Return to the table and continue to step 6.

Practice the Concept: Select the Sales Filter button and point to Number Filters . Select Top 10 from the submenu. In the Top 10 AutoFilter dialog box, select Bottom in the first box, 15 in the second box and Percent in the third box, then click OK . Notice that only three values lie in the bottom 15 percent.

Page 52

OFFICEPRO, Inc.