Excel ERP System | Sales, Purchase & Inventory Management
Built a practical Excel-based ERP system to manage customers, products, vendors, purchases, sales, and inventory.
The system automatically tracks purchased and sold quantities, current stock, stock value, sales, purchases, and profit/loss using Excel formulas and Pivot Tables.
Key skills: Excel, VLOOKUP, SUMIF, Pivot Tables, Inventory Management and Business Reporting.:
I prepared financial records, expense reports and administrative documents. I organized data in Excel and maintained clear records for financial and office management.