Filter

excel 2010 working with filters

1. Computer Skills- Working with Filter in Excel Microsoft Excel Microsoft Office 2010-Illustrated By Dr. Zahraa Fadhil Muhsin Uruk University 1

2. Limiting Data That Appears on Your Screen by using Filter & advance Filter Objectives 2

3. Introduction to Filter Excel can hold as much data as you need them to, but you might not want to work with all the data in a worksheet at the same time. You can limit the data shown on a worksheet by creating a filter , which is a rule that selects rows to be shown in a worksheet.

4. Filter click the cell in the data you want to filter Home tab->Editing group->Sort & Filter->Filter . When you do, Excel displays a filter arrow at the right edge of the top cell in each column of the data. The arrow indicates that the Excel AutoFilter capability is active. 4

5. Important When you turn on filtering, Excel treats the cells in the active cell’s column as a range . You should always have a label at the top of the column you want to filter. If you don’t, Excel treats the first value in the list as the label and doesn’t include it in the list of values by which you can filter the data. 5

6. How it work Clicking the filter arrow displays a menu of filtering options and a list of the unique values in the column . Sorting commands , Clear Filter command Filter b y Color command. The next command that appears on the list depends on the type of data in the column. For example, if the column contains a set of dates, the command will be Date Filters. 6

7. Advance Filter Finding Unique Values Within a Data Set Summarizing values can provide valuable information that helps you run your business . It can also be helpful to know how many different values appear within a column. 7 Range Table /data with head Range Criteria Range Copy to

8. Summary Limiting Data That Appears on Your Screen by using Filter & advance Filter 8