- Can get the drop downs created, have done dynamic dropdowns as well where in based on selection of the first the second dropdown will populate the values.
Based on FundName drop down, the XD date would be populated (DropDown)
- Based on fund code selciton the
Fund Name
PayDate
DIvident
OEIC
Can be populated for the tasks.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- 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