🌍 Global Education Metrics Dashboard – Excel

An interactive Excel dashboard exploring global education data for 2023.
It highlights literacy, internet access, schooling, GDP, and population across countries & regions with clean visuals and filters.

---

✨ Features

• 📖 Literacy rates by country & region
• 🌐 Internet access → top & bottom countries
• 🧮 Average years of schooling
• 💰 GDP per capita → regional comparisons
• 👥 Population insights for <80% literacy nations
• 🎛️ Interactive dashboard with slicers (region & country)

---

📂 Dataset & Prep

• Source: Global education statistics (2023)
• Cleaned in Excel:
  • Standardized country/region names
  • Removed special characters (%,$, USD)
  • Converted text → numeric values
  • Handled missing data & removed summary rows

---

🛠️ Tools & Tech

• Microsoft Excel → cleaning, analysis, visualization
• PivotTables, slicers, bar/line/pie/map charts

---

🚀 How to Reproduce

1. 📥 Open the provided Excel file
2. 🔎 Explore PivotTables & charts
3. 🎛️ Use slicers (region/country) to filter dynamically
4. 📊 View insights in the dashboard sheet

---

📌 Key Insights

• 📖 Regions with the highest & lowest literacy rates
• 🌐 Countries with extreme internet access gaps
• 💰 Region with highest GDP per capita
• 👥 Population at risk → countries <80% literacy

---

🌟 Why This Project?

This project demonstrates how Excel alone can be leveraged for:

• Cleaning messy real-world data
• Building PivotTable-driven insights
• Creating a professional interactive dashboard

---

📬 Connect

💼 LinkedIn | ⭐ Star this repo if useful!