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"