Gone through the excel on the items and the sold quantities for 2015.
Can maintain a master Item list in Excel, with its inventory totals and daily sales. Based on which will be able to generate the balance available, profit % etc.
My Skills:
- I have good skills in Excel automation and used extensively the macros/VBA to automate:
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries.
- With summary data plotting graphs, bringing pivot tables etc.
- Outlook autoamtion - Peforming different actions other that using the existing rules, updating calendars based on logic.
- MS Access - Expert in designing table, user input forms and also reporting from data.
- Excel to MS access data porting and conversion and designing new system for use.
- Please review my portfolio on recent projects completed.