How Do I Quickly Tweak All Files in a Folder?

I recently got hooked on Tableau Public. It's pretty awesome! One of the downsides, however, is the need to find yourself some interesting "open" datasets to visualize. As the number of prospective students at British universities has long been of interest to me, I thought I'd check out if UCAS had any publicly available data … Continue reading How Do I Quickly Tweak All Files in a Folder?

How Do I Quickly Refresh All Files in a List?

• 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?