Budget Excel File 3M 2 USER

This analysis was performed using a budget tracking Excel file. The spreadsheet includes financial data such as income, expenses, categories, dates, and budget allocations.

The main goal of the analysis is to understand spending habits, evaluate budget adherence, and identify areas for financial improvement.

Steps of the analysis:

• Data Cleaning & Organization:
  Verified and formatted date entries, categorized expenses/income, and ensured consistency in data structure.

• Budget vs Actual Comparison:

  • Tracked actual spending against allocated budget

  • Highlighted overspending or underspending in specific categories

  • Calculated monthly savings or deficits

• Visualization:

  • Pie charts for expense breakdown by category

  • Bar/line charts for monthly income vs expenses

  • Cumulative savings tracking over time

• Key Insights:

  • Identification of high-cost categories

  • Budget areas that require adjustment

  • Suggestions for cost reduction and better financial planning