Sort, Filter & Tables
Jab data rows me grow karta hai, usko organize aur inspect karne ke liye Sort, Filter aur Excel Tables bahut useful hote hain. In tools ko sahi dataset structure ke saath use karna important hai.
Sort kya karta hai?
Sort records ka order change karta hai. Text A→Z, numbers Smallest→Largest, dates Oldest→Newest jaise options common hain.
Filter kya karta hai?
Filter unwanted rows delete nahi karta; selected criteria ke according temporary visibility change karta hai. Example sirf Sales department ya marks above 80 show karna.
Sort = order badalta hai. Filter = visible records choose karta hai. Dono ka purpose alag hai.
Excel Table
Structured dataset ko Excel Table me convert karne se headers, filters, styles aur expanding ranges ko manage karna easier hota hai.
Good table structure
- Single header row
- Unique, meaningful column names
- Dataset ke beech unnecessary blank rows nahi
- Ek column me consistent data type
- Totals ko raw data rows ke beech mix na karna
Practical example
Employee sheet me columns ho sakte hain: Name, Department, Salary, Joining Date. Filter se sirf IT department show karo, Salary descending sort karo, aur dataset ko Table me convert karke new records add karo.
Practice — Employee list
- 5 employees ka sample data banao.
- Name ko A→Z sort karo.
- Ek department filter karo.
- Salary ko highest to lowest sort karo.
- Dataset ko Table me convert karo.
Browser Excel Lab ka current MVP formulas par focused hai; Sort/Filter interaction next Lab upgrade me add hoga.