1
1. What Is Filtering?
Filtering temporarily displays only the records matching your conditions while hiding all others. The hidden records are never deleted:
👁️ Visible Records
Rows that satisfy all active filter criteria are shown in the grid.
🙈 Hidden Records (Safe & Intact)
Rows not matching criteria are temporarily collapsed. Clearing filters restores them instantly.
3
3. Filter Types: Text, Number, and Date Conditions
🔤 Text Filters
- Equals / Does Not Equal
- Contains / Does Not Contain
- Begins With / Ends With
🔢 Number Filters
- Greater Than / Less Than
- Between (Range)
- Above / Below Average
📅 Date Filters
- Before / After
- This Month / Last Quarter
- Year to Date
4
4. 🔥 Live Lab: Basic AutoFilter Dropdowns
8 of 8 rows visible
| Order ID ▼ | Customer ▼ | Region ▼ | Product ▼ | Status ▼ | Sales Amount ▼ |
|---|---|---|---|---|---|
| ORD001 | Amit | West | Laptop | Completed | ₹55,000 |
| ORD002 | Priya | South | Mouse | Pending | ₹1,500 |
| ORD003 | Rahul | West | Monitor | Completed | ₹12,000 |
| ORD004 | Neha | North | Keyboard | Pending | ₹3,000 |
| ORD005 | Arjun | West | Laptop | Completed | ₹60,000 |
| ORD006 | Karan | South | Monitor | Completed | ₹14,000 |
| ORD007 | Sneha | North | Laptop | Cancelled | ₹45,000 |
| ORD008 | Riya | West | Mouse | Pending | ₹2,500 |
5
5. Number Filters: Greater Than & Between
8 rows matching
| Order ID ▼ | Customer ▼ | Region ▼ | Product ▼ | Sales Amount ▼ |
|---|---|---|---|---|
| ORD001 | Amit | West | Laptop | ₹55,000 |
| ORD002 | Priya | South | Mouse | ₹1,500 |
| ORD003 | Rahul | West | Monitor | ₹12,000 |
| ORD004 | Neha | North | Keyboard | ₹3,000 |
| ORD005 | Arjun | West | Laptop | ₹60,000 |
| ORD006 | Karan | South | Monitor | ₹14,000 |
| ORD007 | Sneha | North | Laptop | ₹45,000 |
| ORD008 | Riya | West | Mouse | ₹2,500 |
8
8. What Is an Excel Slicer?
A Slicer is a clickable visual button container that filters connected Tables or PivotTables. It replaces small dropdown menus with prominent dashboard buttons:
| Feature | Standard AutoFilter Dropdowns | Visual Excel Slicers |
|---|---|---|
| Interface | Dropdown popup list inside header cells | Floating interactive button tiles |
| Visibility | Must click header arrow to see active choices | Selected vs unselected items visible at a glance |
| Best Used For | Complex conditions (Contains, >, Between) | Categorical dashboard filtering (Region, Status, Brand) |
| Multi-Table Sync | Filters only the single active table | Can connect to and filter multiple PivotTables at once |
10
10. 🔥 Live Lab: Interactive Single Slicer
Click the buttons in the Region Slicer below to filter the table:
Region
| Order ID | Customer | Region | Product | Sales |
|---|---|---|---|---|
| ORD001 | Amit | West | Laptop | ₹55,000 |
| ORD002 | Priya | South | Mouse | ₹1,500 |
| ORD003 | Rahul | West | Monitor | ₹12,000 |
| ORD004 | Neha | North | Keyboard | ₹3,000 |
| ORD005 | Arjun | West | Laptop | ₹60,000 |
| ORD006 | Karan | South | Monitor | ₹14,000 |
| ORD007 | Sneha | North | Laptop | ₹45,000 |
| ORD008 | Riya | West | Mouse | ₹2,500 |
11
11. Multi-Slicer Dashboard Slicing (AND Logic)
Multiple slicers combine their selections to narrow down data:
Region
Status
Product
| Order ID | Customer | Region | Product | Status | Sales |
|---|---|---|---|---|---|
| ORD001 | Amit | West | Laptop | Completed | ₹55,000 |
| ORD002 | Priya | South | Mouse | Pending | ₹1,500 |
| ORD003 | Rahul | West | Monitor | Completed | ₹12,000 |
| ORD004 | Neha | North | Keyboard | Pending | ₹3,000 |
| ORD005 | Arjun | West | Laptop | Completed | ₹60,000 |
| ORD006 | Karan | South | Monitor | Completed | ₹14,000 |
| ORD007 | Sneha | North | Laptop | Cancelled | ₹45,000 |
| ORD008 | Riya | West | Mouse | Pending | ₹2,500 |
14
14. Filter vs Slicer Decision Challenge
A. Find all orders where Sales are greater than ₹50,000:
B. Allow non-technical executives to click buttons to filter regions:
C. Find customer names containing the letters "an":
D. Build an interactive multi-table dashboard panel:
16
16. 🔥 Live Final Challenge: 10-Row Executive Workbench
Region
Product
Status
| Order ID | Customer | Region | Product | Status | Sales Amount |
|---|---|---|---|---|---|
| ORD001 | Amit | West | Laptop | Completed | ₹55,000 |
| ORD002 | Priya | South | Mouse | Pending | ₹1,500 |
| ORD003 | Rahul | West | Monitor | Completed | ₹12,000 |
| ORD004 | Neha | North | Laptop | Pending | ₹45,000 |
| ORD005 | Arjun | West | Laptop | Completed | ₹60,000 |
| ORD006 | Karan | South | Monitor | Completed | ₹14,000 |
| ORD007 | Sneha | North | Mouse | Cancelled | ₹1,800 |
| ORD008 | Riya | West | Mouse | Pending | ₹2,500 |
| ORD009 | Mohit | South | Laptop | Completed | ₹52,000 |
| ORD010 | Ananya | West | Monitor | Completed | ₹24,000 |
| Total Visible Sales (10 orders) | ₹267,800 | ||||
18
18. Quick Check Assessment Quiz
Test your understanding of AutoFilters, Slicers, and selection states:
TEST YOUR KNOWLEDGE
Excel Filters & Slicers Assessment Quiz
Test your mastery of AutoFilter conditions, Slicer connections, and dashboard design.
Q1
1. What does filtering do in Microsoft Excel?
19
19. Accuracy & Production Best Practices
Guidelines for professional business dashboard engineering:
- Connect Slicers to Multiple PivotTables: Right-click any Slicer and select Report Connections to tie a single Slicer to multiple PivotTables and charts on your dashboard simultaneously.
- Remember That Slicers Require Tables or PivotTables: Slicers cannot be inserted directly on raw, unformatted coordinate ranges. Always convert the data with
Ctrl + Tfirst.