I am experienced in IT Infrastructure management and integration, business analysis and troubleshooting.
I have been working in Excel VBA and formula helping multiple colleagues in different companies, so as to automate all those manual or tedious Excel operations and will minimize the human errors.
I'm good at all Excel formula, creating new functions, VBA programming in Excel, and also good at other Office applications. Other than Microsoft Office, I'm specialized in IT infrastructure, networking, and security, data analysis, graphics design and audio & video editing.
Excel VBA projects
- read in huge amount of data, generated from SAP systems, and automate the clean up, formatting, then perform the data analysis and calculation with VBA
- automate the messy data and convert into readable format via VBA programming
- automate the financial data and shorten the reporting via VBA programming, so that it shorten the 2-week manual effort to 30 mins
- migrat of VBA code to Office 2016