I can plug in the additional functionality into the current Heating Design Excel sheet that you have.
Have very good expertise in Excel automation using macros, VBA.
I have recently done some complicated calculations including the advanced formulas like index,arrays, scientific formulas, lookups etc.
Ex: Scoring mechanism, assigning weightage to words founds and overall occurence assign some value.
Canadian Tax calculations - Based on multiple control tables....
Making a union of data columnwise and rowwise.....
Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
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.
- Please review my portfolio on recent projects completed.