Skip to main content
University of Texas University of Texas Libraries

Data & Donuts

Organizing Data in Spreadsheets

Organizing Data in Spreadsheets

October 5, 2018

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.

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 2.0 Generic License.