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.