Student Budget & Income Analysis (Excel)

Overview

This project analyzes student budget and income data using Microsoft Excel. The goal was to organize financial information, calculate total budget values, and create visualizations to identify trends across age, gender, and year of study.

Tools Used

• Microsoft Excel (PivotTables, charts, formatting, sorting)

Key Tasks Completed

• Cleaned and organized student financial data
• Created calculated columns to determine total budget values
• Applied Canadian currency formatting for clarity and consistency
• Sorted records by multiple attributes such as index and age
• Built PivotTables to summarize income and budget information
• Created charts to visualize trends by age, gender, and year in school

Visualizations

The workbook includes charts that show:

• Income distribution by age
• Income trends by gender and year of study

Outcome

This project demonstrates the ability to transform raw financial data into meaningful insights using Excel reporting tools.

File Included

• Student_Budget_Income_Analysis.xlsx