Can get the Excel sheet imported into the database.
Have expertise in MS Access and Excel automation.
Have experience in database designing, ER diagrams and table relationships and constraints, have done similar freelancer projects.
Create the simple forms for data entry and reporting on the same.
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Please review my portfolio on recent projects completed.
- Have done Heating design based on current/voltage restrictions for each mat having multiple models, exam results grading by finding keywords, Canadian Province tax calculations based on province parameters, , merger of rows and columns of data based on key values
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.
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables
- Outlook automation - Performing 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.