Description
We use spreadsheet programs for entering, organizing, subsetting, and sorting data, for generating statistics and plots, and more. This course shows you some best practices that will result in fewer mistakes, greater reproducibility, and easier use of other software tools with data exported from spreadsheets.
Prerequisites
Participants should be comfortable using a computer and navigating files and folders. No prior programming experience is necessary.
Details
Learning Objectives
- Decide whether a spreadsheet or a database is the more suitable tool for a project
- Reorganize and reformat a spreadsheet to avoid common problems
- Parse and format dates using spreadsheet functions
- Detect and correct some kinds of data errors in spreadsheets
- Export spreadsheet data in portable formats
- Use a pivot table to summarize data in different ways
Who Should Enrol
This workshop is designed for graduate and undergraduate students using spreadsheet software in a research context for the first time.