✅ Excel Basics Part 7 – Sorting, Filtering & Conditional Formatting 📊✨

These tools help you analyze and highlight data quickly without writing formulas.

1️⃣ Sorting Data
• Sort A to Z (ascending) or Z to A (descending)
• Sort by one or multiple columns (e.g., by Marks, then Name)

📌 How:
→ Select data → Data tab → Sort

2️⃣ Filtering Data
• Show only rows that match certain criteria
• Example: Show only “Yes” in Attendance

📌 How:
→ Select headers → Data tab → Filter → Use dropdowns

3️⃣ Conditional Formatting
• Visually highlight values based on rules
• Useful for spotting high/low scores, duplicates, trends

📌 Examples:
🔹 Highlight cells > 80:
→ Select range → Home → Conditional Formatting → Highlight Cell Rules → Greater Than

🔹 Color scale for Marks:
→ Green for high, red for low

🔹 Highlight duplicates:
→ Conditional Formatting → Highlight Cell Rules → Duplicate Values

📊 Practice Task:
Use this table: