๐ Day 55: Sorting Data (MS Excel) – Hinglish
Sorting Data (MS Excel) – Hinglish
๐ Sorting kya hota hai?
Excel me data ko order (เค्เคฐเคฎ) me arrange karna = Sorting.
๐ Sorting types:
A to Z (Ascending) ⬆️
Z to A (Descending) ⬇️
Small to Large
Large to Small
๐ข Sorting ke types
1️⃣ Alphabetical Sorting (Text)
๐ Example:
Names → A to Z / Z to A
2️⃣ Numerical Sorting (Numbers)
๐ Example:
Marks → Small to Large / Large to Small
3️⃣ Date Sorting
๐ Example:
Dates → Oldest to Newest / Newest to Oldest
๐ ️ Data kaise sort kare?
✅ Method 1: Simple Sort
Data select karo
Data Tab → Sort A to Z / Sort Z to A
✅ Method 2: Custom Sort (Advanced)
Data select karo
Data Tab → Sort
Column choose karo (Name / Marks etc.)
Order choose karo (A to Z / Largest to Smallest)
OK click karo
๐ Example Data
| Name | Marks |
|---|---|
| Rahul | 80 |
| Priya | 90 |
| Amit | 70 |
| Neha | 60 |
๐ Tasks:
Marks ko High to Low sort karo
Names ko A to Z sort karo
⚠️ Important Tips
✅ Sorting se data ka order change hota hai
✅ Header row select karo (My data has headers)
✅ Sirf ek column nahi, poora table select karo
๐งช Practice Task (Important)
๐ Excel me:
Ek marksheet banao
Marks column ko descending order me sort karo
Names ko ascending order me sort karo
๐ Short Notes (Exam ke liye)
๐ Sorting = Data ko order me arrange karna
๐ Ascending = A to Z / Small to Large
๐ Descending = Z to A / Large to Small