Excel applications
Excel & VBA — Invoicing management
Invoicing workbook with quotations, orders, deliveries, invoices and a dashboard, documented by the report and VBA code.
Academic team project
All projects
- Project type
- Academic
- Documented period
- 2025
- Team
- Team of 3
Overview
Excel application from a three-person academic team assignment documented in 2025. The workbook organizes commercial documents and invoicing tracking.
Contribution and project context
Academic team project. The documents do not identify individual task allocation.
Approach
Workbook inspection
Read-only inspection of eight worksheets, formulas, tables and VBA modules without executing macros.
Document automation
Analysis of document creation, cancellation, printing and recording procedures.
Work and deliverables
Commercial workflow
Quotations, orders, deliveries and invoices; pre-tax, VAT and total calculations and invoice archiving.
Dashboard
Revenue, paid/unpaid invoices, time trends and payment breakdown.
Findings and recommendations
The workbook illustrates how structured inputs support monitoring indicators, using VLOOKUP, IFERROR and VAT calculations.
Tools and skills
Excel · VBA · RECHERCHEV / VLOOKUP · Tableaux croisés dynamiques
Visual evidence from source materials
Scope and limitations
Academic workbook inspected read-only. Macro execution in Excel has not been tested. Client data and the raw workbook are not published.
Verified sources
APP Gestion de la Facturation F.xlsm
Rapport-G3-KANTANA-KANTANA-LAKHAL.pdf
More to explore
Python — Invoicing application
Tkinter application with clients, products, invoices, SQLite, Excel import and Matplotlib reports.
Academic application — individual role not identified in the sources
Excel & VBA — Stock management
Goods, stock entries, exits and inventories with stock indicators and VBA procedures.
Academic team project
Excel & VBA — Personal budget
Transaction organization and monthly category-based budget tracking with Excel formulas and charts.
Academic team project


