You’ve spent months collecting precious research data, now it’s time to analyse it. You open up the first spreadsheet, recorded some time last year, and react in horror:
What does that yellow highlighting mean?
What the hell is in column J?
Is 12/01/18 the 12th of January, 2018 or the 18th of January, 2012?
Why does this spreadsheet have 10 columns and the next has 15?
Who wrote this!? (Oh yeah, it was me …)
Ever had feelings like this? Then this is the talk for you! I’ll give practical advice for data organisation, focusing on spreadsheets, that will make your life easier, not just when it comes time to analyse your data but also when doing data entry.