I have very good expertise in Excel automation using macros, VBA , formulas
Consolidation of data from multiple sheets, validating against values and summarising them in Excel.
On click of a button.
Also expert in MS Access - designing tables, queries and report designing.
Can import the excel data into Access for building easy to use user entry screens.
Can complete this task in a day.
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.
• 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.