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?
a great guide to cleaning data in Excel (for when you have to) >> How to prepare your data for analysis and charting in Excel & Google Sheets