Hi, I develop inventory modules in Microsoft Excel & VBA. the secured module enables you to manage inventory transactions in a spreadsheet by Bill Of Materials, cost centers, currencies and to get immediate reports and info. you will be able to issue order_forms, updated its status (open orders, delivery status payments) and issues status reports regarding the orders.
There is a search engine with high search capability to find a specific record (or group). During the process, Excel validates the information and prepares reports and documents based on the needed parameters and criteria. There is a report generator which enables you to develop templates independently. And more, the files are secured by username login and password.
I am an expert in Excel with comprehensive knowledge of advanced formulas, pivot tables, and Visual Basic Application. I can create customized spreadsheets by preparing dynamic dashboards, screen layouts (user-forms), drop-down boxes, generator reports, and charts.
During my time serving as CFO, Controller, and Chief Accountant at different global parent companies, and I gained knowledge and expertise in Financial Reports, accounting, consolidating, forecasting, and budgeting.