Sort & Filter in Excel

🔄 Sort Kya Hai?

Hindi: Excel mein data ko kisi order mein arrange karne ko Sort kaha jata hai.

English: Sorting means arranging data in a specific order.

Sort ke Common Options:

• A to Z
• Z to A
• Smallest to Largest
• Largest to Smallest

🔤 Text ko Sort Karna

Names ya cities ko alphabetical order mein arrange karne ke liye Sort ka use kar sakte hain.

🔢 Numbers ko Sort Karna

Numbers ko Smallest to Largest ya Largest to Smallest arrange kiya ja sakta hai.

🔎 Filter Kya Hai?

Hindi: Filter ka use karke hum large data mein se sirf required information ko display kar sakte hain.

English: Filtering displays only the data that matches selected conditions.

📊 Filter Example

Maan lijiye employee data mein different departments hain. Hume sirf IT department ke employees dekhne hain.

⚙️ Filter Apply Kaise Karein?

Excel mein Filter apply karne ke basic steps:

1. Apne data ko select karein.
2. Data tab par click karein.
3. Filter option select karein.
4. Column ke dropdown par click karein.
5. Required value select karein.

⚖️ Sort vs Filter

Sort data ko arrange karta hai, jabki Filter unwanted data ko temporarily hide kar deta hai.

💼 Business mein Use

Sort aur Filter ka use business data mein bahut common hai.

• Sales Reports
• Employee Records
• Customer Data
• Lead Data
• Product Lists
• Stock Records
• Expenses

📋 Lead Data Example

Lead generation data ko filter karke specific city ya status ke leads easily dekhe ja sakte hain.

⚠️ Important Note

🎓 Lesson Summary

Is lesson mein humne seekha:

✅ Sort kya hai
✅ A to Z Sort
✅ Z to A Sort
✅ Smallest to Largest
✅ Largest to Smallest
✅ Filter kya hai
✅ Filter apply karna
✅ Sort vs Filter
✅ Business mein Sort & Filter ka use