📊 Student Marks Analysis (Excel Project)

🧾 Project Overview

This Excel project analyzes student performance using data-driven techniques.
It demonstrates data cleaning, use of formulas, and visualization to extract insights from marks data.
The goal is to understand student progress, identify top performers, and summarize subject-wise results.

🗂️ Dataset Details

• File: Student_Marks_Data.xlsx
• Columns: Student Name, Subject, Marks, Total, Average, Grade
• Records: 10 students, 3 subjects each (Math, Science, English)

🧮 Excel Techniques Used

• Formulas: SUM, AVERAGE, IF, COUNT, ROUND
• Conditional Formatting for Grades
• Data Validation for clean inputs
• Sorting and Filtering
• Charts: Pie Chart & Column Chart

📈 Insights

• Identified top-performing students
• Compared subject-wise averages
• Displayed grade distribution visually