How to prepare your data for analysis and charting in Excel & Google Sheets
The methods and Excel formulas you'll need most often to get your data ready to analyze or plug into Datawrapper.
Lisa Charlotte Rost
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