Excel applications

Excel & VBA — Stock management

Goods, stock entries, exits and inventories with stock indicators and VBA procedures.

Academic team project

All projects
Excel & VBA — Stock management
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

Explore my skills and background

More to explore

Python — Inventory management
Python applications

Python — Inventory management

Tkinter and SQLite desktop application: products, suppliers, movements, dashboards and Excel exports.

PythonTkinterSQLite

Academic application — individual role not identified in the sources