Excel applications

Excel & VBA — Personal budget

Transaction organization and monthly category-based budget tracking with Excel formulas and charts.

Academic team project

All projects
Excel & VBA — Personal budget
Project type
Academic
Documented period
2025
Team
Team of 3

Overview

Third application in the academic team assignment: three sheets dedicated to the dashboard, transactions and budget.

Contribution and project context

Academic team project. The documents do not identify individual task allocation.

Approach

  • Budget and transactions

    Analysis of category organization and comparison between budgets and actual amounts.

  • Formulas and input

    Inspection of SUMIF, SUMPRODUCT, INDEX/MATCH formulas and the VBA transaction-entry procedure.

Work and deliverables

  • Monthly tracking

    Budget/actual comparison and category-based income and expense breakdown.

  • Visualization

    Eight dashboard charts identified in the workbook.

Findings and recommendations

The exercise illustrates budget organization and variance monitoring, without personalized financial advice.

Tools and skills

Excel · VBA · SUMPRODUCT · INDEX / MATCH

Visual evidence from source materials

Scope and limitations

The raw workbook and transaction amounts remain private. The diagram is a summary of verified worksheets, not an application screenshot.

Verified sources

Gestion Finances Personnelles.xlsm

Rapport-G3-KANTANA-KANTANA-LAKHAL.pdf

Explore my skills and background

More to explore