Lesson Schedule

00:00 1. Introduction What are the basic principles for using spreadsheets for good data organisation?
00:10 2. Organising data in spreadsheets How do we organise and format data in spreadsheets for effective data use?
00:35 3. Common spreadsheet errors What are some common challenges with formatting data in spreadsheets and how can we avoid them?
01:00 4. Dates as data What are good approaches for handling dates in spreadsheets?
01:25 5. Quality assurance and control How can we carry out basic quality control and quality assurance in spreadsheets?
01:50 6. Exporting data How can we export data from spreadsheets in a way that is useful for downstream applications?
02:00 Finish

The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.