I have good expertise in Excel automation using macros and VBA.
Have used formulas, lookups and pivot tables.
Have done data migration, comparison and validation using macros.
Went through the PDF and the macro excel + another excel.
I can complete this in 3 days time.
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.