New article! I wrote down the Excel techniques & formulas I use the most to clean up data sets (so that I can use them for #dataviz). Which techniques are you using all the time? Which ones did I miss? Which ones should I add? https://blog.datawrapper.de/prepare-and-clean-up-data-for-data-visualization/
@lisacrost A few favorites of mine: named ranges, index/match instead of vlookup, and most crucially "see version history"
vis.social is an open social platform for creative people, especially anyone in data, visualization, creative coding, and related arts and research.