About This Service
I will handle all the Excel related coding for you. The efficiencies and customized capabilities my work of Excel automation would give you will prove very valuable.
Among my vast VBA knowledge, below are some of the automation tasks I have done recently -
o I can design my own functions via VBA, you could use in any cell on excel
o I can automate creation of pivot tables using VBA
o Data cleansing
- Something like converting 5 digit values into 6 digits when zeros in the beginning get eliminated
- When getting data from outside, numbers may not be in the best format. Like they could have spaces everywhere or commas in between, instead of manually editing the same; I could automate that on VBA
o Import data into one main excel file (workbook) from multiple other excel files
o Create Userforms and run a monte carlo simulation