Jessica Trelogan, Research Data Services, UT Libraries
Spreadsheets can be a powerful tool for entering, analyzing, and managing data, but it’s crucial to ensure that they are well-formatted from the outset, before you even start entering data. This 1.5 hour hands-on* workshop will teach you how to think about data organization to increase your efficiency and help ensure that your data are reusable. We will discuss good data entry practices, how to avoid common formatting mistakes, basic quality control, data manipulation, and exporting.
Slides are here.
Exercise data are here.
*Laptops are available for check-out. Feel free to use your own if you prefer, with the spreadsheet software of your choice (e.g., Open Office or Microsoft Exel) pre-installed.
This work is licensed under a Creative Commons Attribution-NonCommercial 2.0 Generic License.