I have good data entry and webscrapping, data collection knowledge.
I can complete this data collection in a day for the 120 listed.
Also have good expertise in Excel - data consolidation, merging, searching and summarising using formulas, lookup and pivot tables.
Use automation - macros, VBA scripting.
My skills in details:
• 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.