This project focused on cleaning and organizing a raw dataset in Microsoft Excel. I corrected formatting issues, organized the data into a clear structure, removed duplicate and inconsistent entries, and prepared the final spreadsheet for easier use and analysis.
The project demonstrates my skills in Data Entry, Data Cleaning, Excel Formatting, and Data Organization.
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.: