A short series aimed at upskilling distance learning students on how to make the best use of excel. In this lecture I cover Broman & Woo's principles of organising data in spreadsheets. 

Contents:
00:20: Tidy data principles
01:17: Overview of Broman & Woo's principles
03:00: Consistency, naming and date formats
05:50: Naming examples
10:10: Data entry, missing data, and formula
12:50: Data validation, machine readable and backups
14:50: Test yourself, what problems do you see with this data?
15:30: Tidy data along with me