Lesson 4.3 – Filtering Data

Filtering allows you to display only the rows that match specific criteria while temporarily hiding the rest. It is one of the most useful tools in Excel for exploring, cleaning, and analyzing data without modifying or deleting anything.

---

1. What Is Filtering?

Filtering helps you focus on the information you need by showing only the rows that meet your conditions. You can filter text, numbers, dates, and even colors.

Examples:

• Show only “Electronics” products
• Display sales greater than 500
• Show dates from the last 30 days
• Filter rows with a specific color

---

2. How to Apply a Filter

Method 1 – Using the Ribbon:

1. Select your dataset.
2. Go to Home → Sort & Filter → Filter.
3. Filter arrows will appear on each column header.

Method 2 – Using a Table:

If your data is formatted as an Excel Table, filters are automatically enabled.

---

3. Filtering Text

Text filters allow you to show rows that match specific words or patterns.

Examples:

• Equals “Completed”
• Contains “Pro”
• Does not contain “Test”
• Begins with “A”

How to use:

1. Click the filter arrow on a text column.
2. Select Text Filters.
3. Choose the condition you need.

---

4. Filtering Numbers

Number filters help you analyze numeric data quickly.

Examples:

• Greater than 100
• Between 50 and 200
• Top 10 items

How to use:

1. Click the filter arrow on a numeric column.
2. Select Number Filters.
3. Choose your condition.

---

5. Filtering Dates

Date filters allow you to analyze time‑based data.

Examples:

• This week
• Last month
• Next quarter
• Between two dates

How to use:

1. Click the filter arrow on a date column.
2. Select Date Filters.
3. Choose the time period you want.

---

6. Using the Search Box

Every filter menu includes a search box. This is extremely useful when your column contains many unique values.

Example:

Typing “pro” will show items like “Product A”, “Project X”, “Profile 1”.

---

7. Clear Filters

To remove all filters and show the full dataset:

Home → Sort & Filter → Clear

Or click the filter icon and choose Clear Filter.

---

8. Common Mistakes to Avoid

• Filtering a single column instead of the entire dataset
• Forgetting that filters hide rows