📊 Day 56: Filtering Data (MS Excel) – Hinglish

Filtering Data (MS Excel) – Hinglish

📌 Filtering kya hota hai?

Excel me data me se sirf required (जरूरी) data dikhana = Filtering.

👉 Sorting = data ko order me lagana
👉 Filtering = data me se specific data dikhana

---

🔍 Filtering ka use

✅ Specific marks wale students dikhana
✅ Particular name / class ka data dikhana
✅ High / low values search karna

---

🛠️ Filter kaise lagaye?

✅ Steps:

1. Data select karo

2. Data Tab → Filter

3. Header me dropdown arrow (▼) aa jayega

---

🎯 Filter ka use kaise kare?

1️⃣ Text Filter (Name)

👉 Example:

• Sirf “Rahul” ka data dikhana

Steps:
Header arrow → Search box me Rahul type karo

---

2️⃣ Number Filter (Marks)

👉 Example:

• Marks > 70 dikhana

Steps:
Marks column → Number Filters → Greater Than → 70

---

3️⃣ Multiple Filter

👉 Example:

• Marks between 60 and 90

Steps:
Number Filters → Between → 60 & 90

---

4️⃣ Clear Filter

👉 Steps:
Data Tab → Clear
OR
Filter arrow → Clear Filter

---

📊 Example Data

Name	Marks
Rahul	80
Priya	90
Amit	70
Neha	60
Rohit	85

👉 Tasks:

• Marks > 75 filter karo

• Name = Priya filter karo

---

⚠️ Important Points (Exam ke liye)

✅ Filter sirf data ko hide/show karta hai, delete nahi
✅ Filter header row par lagta hai
✅ Filter se analysis easy hota hai

---

🧪 Practice Task (Important)

👉 Excel me:

1. Ek marksheet banao

2. Filter lagao

3. Marks > 80 wale students dikhana

---

📝 Short Notes (Exam ke liye)

👉 Filtering = Specific data show karna
👉 Data Tab → Filter

---

⬅ Previous Day

                            Next Day ➡