Excel applications
Excel & VBA — Personal budget
Transaction organization and monthly category-based budget tracking with Excel formulas and charts.
Academic team project
All projects
- 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
More to explore
Excel & VBA — Invoicing management
Invoicing workbook with quotations, orders, deliveries, invoices and a dashboard, documented by the report and VBA code.
Academic team project
Excel & VBA — Stock management
Goods, stock entries, exits and inventories with stock indicators and VBA procedures.
Academic team project

