Excel applications
Excel & VBA — Stock management
Goods, stock entries, exits and inventories with stock indicators and VBA procedures.
Academic team project
All projects
- Project type
- Academic
- Documented period
- 2025
- Team
- Team of 3
Overview
Second application in the same academic team assignment: a seven-sheet workbook dedicated to stock movements and inventory.
Contribution and project context
Academic team project. The documents do not identify individual task allocation.
Approach
Stock model
Inspection of goods, entries, exits, inventories and processing sheets.
Calculations and VBA
Analysis of reference lookups, conditional aggregations and procedures for adding goods and movements.
Work and deliverables
Inventory
Comparison of theoretical and counted stock and tracking of stock values.
Visual monitoring
Entry/exit charts, value trends and products requiring replenishment.
Findings and recommendations
The report connects operational movements with a concise view of replenishment needs.
Tools and skills
Excel · VBA · SUMIF · Inventory
Visual evidence from source materials
Scope and limitations
Academic project; macros were not executed and no measured productivity improvement is claimed. The source workbook remains private.
Verified sources
Application Gestion Stock.xlsm
Rapport-G3-KANTANA-KANTANA-LAKHAL.pdf
More to explore
Python — Inventory management
Tkinter and SQLite desktop application: products, suppliers, movements, dashboards and Excel exports.
Academic application — individual role not identified in the sources
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 — Personal budget
Transaction organization and monthly category-based budget tracking with Excel formulas and charts.
Academic team project



