-Can get this attached PDF converted to Excel per the format template required in Excel.
-Have done similar PDF to Excel reporting.
- 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, retrieving calendar, tasks or scheduling.
- MS Access - Expert in designing table, user input forms and also reporting from data.
- Excel to MS access data porting and conversion and designing.