Assuming Excel is your play tool and that you need to handle data worth of 30,000 rows + in order to produce your analyses, below are some tips that could help improve and optimize your spreadsheet usage: 1. Do change the default csv connection properties! • Prompt for file on refresh: achieves nothing but render … Continue reading 10 Best Practices of Spreadsheet Management
• Do you need to provide monthly Excel stats to a bunch of external customers? • Do you need to refresh the data in 50+ workbooks every month? • Are you tired of mind-numbingly opening a workbook after workbook only to press "Refresh All"? There's a way to avoid all these! 1) Put the file … Continue reading How Do I Quickly Refresh All Files in a List?
I really, really dislike non-tabular datasets and systems that spew out data in a spreadsheet format! The only way to crunch any meaningful summary out of such dataset is through some extensive formula usage and the subsequent analysis is an incredible pain to maintain on a regular basis. On top of it, filtering can be … Continue reading How Do I Quickly Refilter all My Tables with VBA?