My main areas of expertise are VBA macros (Excel, web scraping) and WordPress speed optimization, where I regularly achieve 95+ score in Google PageSpeed Insights / GTmetrix. I also develop WordPress plugins, mostly WooCommerce-related. In Excel VBA I like to work on big data sets, for example, stock market and Forex data, where code performance matters. I'm proficient in standard Excel tools: formulas, charts, graphs, pivot tables, conditional formatting, Solver, etc.
VBA:
- over 8 years of experience
- Excel automation
- web scraping
- passing data between Excel, Word, text files, etc.
- rearranging data structure
- sending e-mails based on Excel data
- operations on files and folders
- UserForms
- custom formulas
- macro speed optimization
WordPress (PHP, jQuery, JavaScript, HTML, CSS)
- over 3 years of experience
- website speed optimization (Google PageSpeed Insights, GTmetrix)
- fixing websites, small customizations
- plugin development, mostly for WooCommerce