- Went through the Excel haaving info on
- Analysis/Commentary — Views Charts — 2015-0593341R3 -- Loss consolidation, Date and Reference and having multiple sheets V, CL, Na., Sh....
- The doucument containting details on CRA Views, Ruling, 2015-0593341R3 -- Loss consolidation
and the Visio drawing showing XXX parent, CDN Parent, Lender.... etc in a tree structure.
- Have expertise in Excel automation, Word and have worked on Visio drawings.
- If you provide more details on what is getting transformed from Word to Excel and then Word to Visio or Excel to Visio then accordingly the modifications or changes to Excel automation or Visio drawing could be made.
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- 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.,
- Data extraction using API.
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables
- Pl. review my portfolio on recent projects.
Sample HighComplex Projects using Macros:(via Freelancer)
- Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations.
....