Skip to content

Latest commit

 

History

History
27 lines (20 loc) · 811 Bytes

File metadata and controls

27 lines (20 loc) · 811 Bytes

Personal Expense Tracker (Excel)

📌 Project Overview

This project is an Excel-based Personal Expense Tracker designed to record, analyze, and visualize daily expenses. It helps understand spending patterns through category-wise analysis and interactive dashboards.

🛠 Tools & Features Used

  • Microsoft Excel
  • Data Validation (Dropdowns)
  • Conditional Formatting
  • Pivot Tables
  • Charts (Pie Chart)
  • Excel Tables for dynamic updates

📊 Key Analysis

  • Category-wise expense distribution
  • Automatic update of analysis when new data is added
  • Highlighting high-value expenses

📁 File Included

  • Personal_Expense_Tracker.xlsx

🧠 Learnings

  • Structured data handling in Excel
  • Real-world data analysis workflow
  • Building dynamic and scalable reports