- Can get the data with the 7 columns sorted every time occurrence.
- Have done similar LeaderBoard, where the data gets populated in the Excel file, but based on the gaming, number of players and certain conditions it would populate the outputs automatically no manual intervention. (Freelancer project).
- 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.,
- 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.
- Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables.
- University, US - Scoring the answer sheets based on keyword and number of occurences.