Inventory and Stock Control dashboard in Excel: stock value by category, auto-updating reorder list and units sold, driven by live formulas. Built on demo data. Self-initiated demo, unpaid.
Developed a management accounts reporting process designed to help businesses understand their financial performance and make informed business decisions.
Inventory data cleanup — self-initiated Excel demo using synthetic data. AI-assisted, not a client engagement. The example tracks original rows, inconsistent SKU/category/price formats and duplicate copies. Missing values are flagged rather than invented. The image shows the synthetic source and duplicate-removal trace. Existing workbook and before/after demonstration: https://www.truelancer.com/portfolio/excel-data-cleaning-inventory-before-and-after-demo-335964