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 sciArt, data, visualization, creative coding, and related arts and research. English is the common language of the instance.