Went through the doc file, and Grill and SolverGrill xls along with Access database containing 4 tables.
Have expertise in handling the Excel automation, formulas along with Access database designing, querying.
Once confirmed will perform per the steps in the doc, and confirm on what needs to be done and delivered.
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Excel macros - I have done complicated data processing using Excel macros for Exam sheet evaluation, (Recent)Circuit designing based on mulitple wire models, amps/voltages, calculations of taxes for Canadian citizen based on tax slabs per Fed and Provincial tax, based on the salary ranges etc.
- Outlook macros - - Samples - Extracting mail contents parsing and sending to different customers, getting the task and calendar events from Outlook to Excel
- Pl. review my portfolio on recent projects.
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 - extracting, modifiying mails in Inbox