- Can get the data from the Excel columns and have them placed in the Microsoft Word template per the field position in Word and create the file with the sepefific file name.
- Similarly generate the Word files for the 500-1000 rows of data creating the necessary Word files.
- Have expertise in both Excel and Word automations and have created similar template filling from Excel to Word.
My Skills:
- 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.,
- 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 projects done - https://www.freelancer.com/u/satishtl