Improving Excel file performance

par Taisho
Portfolio

I am an expert in making Excel files open, close, save and work faster and in decreasing their size. I created a macro which lists worksheets by their size in MB. It's a good starting point when file size is suspiciously large. I know multiple ways of improving speed of workbook, for example: - changing file format - finding and deleting blank ranges treated as used - eliminating unnecessary external connections - replacing big tables with ranges (for Excel 2016 and newer not needed) - replacing formulas with faster counterparts (especially so-called volatile formulas) - replacing formulas with macros - optimizing existing VBA macros, in which I have the highest level of proficiency - scanning worksheets for objects like vector graphics which can be oversized and completely slow Excel down

image of username Taisho Flag of Poland Góra, Poland

Me concernant

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

$15 $ US / h

69 évaluations
5.4

Étiquettes