Hi, I can produce a filtered lead list by a search engine with high search capability based on an external database in Microsoft Excel and VBA. Excel can provide an internal list based on a client list, a product catalog and a primary database with the orders.
I am a financial expert and guru in Excel and Excel-VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts.
Furthermore, I have an experience in Financial Reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation.
With these skills, I develop complex of modules in a simplified and logical manner.