Inventory Management using Microsoft Excel
1. Day-to-day inventory entry 2. Automatic update of the current stock level 3. Check and indicate stock of items which have reached the re-order level 4. Ease of checking for items, using slicer tools 5. The project was done on Excel, using VBA, slicer tools, and complex formulas like v-lookup, index match, nested if loops, etc.
Giới thiệu
Financial analyst and advanced Excel user, I have a work experience of 3+ years. I am an MBA Graduate, specializing in Finance I am well-versed with financial accounting, budgeting & forecasting, financial analysis & modelling, inventory management. I have handled accounts using Quickbooks &Tally ERP. I also have experience in other Microsoft Suite including Access, Power Point, Word and One Note. Services Provided: 1. Management Accounting: Financial Analysis; Cost-Volume-Profit; Financial Budgeting/Forecasting/Simulation; Asset/Cost Management; etc. 2. Financial Modelling : M&A, Project Finance 3. Cost Accounting: Activity-Based Costing; Job Order Costing; Standard Costing; etc. 4. Financial Accounting: Financial Statements; Bank Reconciliation; Quickbooks; Xero; Tally, etc. 5. Advanced Excel - macro, VBA, powerquery, powerpivot, complex formulas 6. Inventory Management - using MS Excel, MS Access 7. Business Consulting & Project Evaluations
