One of my recent posts touched how powerful R is for data cleaning and manipulation, but I want to take a step back and recognize that a ton of science gets done in Excel. And while Excel has many limitations … Continue reading →
Category: spreadsheets
Two Strategies for Working with Dates in Excel
One of the periodic discussions that comes up as a data management evangelist (beside the “data is” v. “data are” debate) is about how Excel is terrible with dates. Excel mangles dates, mangles non-date data into dates, and doesn’t play nice … Continue reading →